Aggregations
Scanner supports some functions for basic aggregations.
Functions are invoked with the parentheses ()
, e.g. count()
, although top-level parentheses are optional. E.g.:
Functions are chained onto text query filter clauses with the |
(vertical pipe) operator, and can be attached to any legal query:
Function arguments can support either numeric or string values. Strings in function arguments may be specified as either bare words, or quoted strings. However, if a string begins with a number, it must be quoted.
Quoted strings in function arguments may be singly- or doubly-quoted, and support the same escape sequences as in the filter query. Note that here, the *
character is simply treated as a character, since function argument strings don't support wildcarding.
Reserved Keywords
The following keywords are reserved in function arguments: by
, as
. Use quotes if you need to pass them as strings to a function.
Last updated