all

all(T.a : boolean) 🡒 boolean, aggregator

Returns true if all the grouped values are true, and returns false otherwise.

Example:

table T = with
  [| as A, as B |]
  [| true,  "a" |]
  [| true,  "a" |]
  [| true,  "b" |]
  [| false, "b" |]
  [| true,  "c" |]

table G[gdim] = by T.B

where T.B != "c"
  show table "" a1b4 with
    gdim
    all(T.A)
    group by gdim

The aggregator returns false on empty groups.

all(T.a : number) 🡒 boolean, aggregator

Returns true if all the grouped values are non-zero, and returns false otherwise.

Example:

table T = with
  [| as A, as B |]
  [| 1, "a" |]
  [| 1, "a" |]
  [| 1, "b" |]
  [| 0, "b" |]
  [| 1, "c" |]

table G[gdim] = by T.B

where T.B != "c"
  show table "" a1b4 with
    gdim
    all(T.A)
    group by gdim

The aggregator returns false on empty groups.

all(T.a : text) 🡒 boolean, aggregator

Returns true if all the grouped values are non-empty, and returns false otherwise.

Example:

table T = with
  [| as A, as B |]
  [| "foo", "a" |]
  [| "foo", "a" |]
  [| "foo", "b" |]
  [| "",    "b" |]
  [| "foo", "c" |]

table G[gdim] = by T.B

where T.B != "c"
  show table "" a1b4 with
    gdim
    all(T.A)
    group by gdim

See also