Operators and Functions
Operators and functions can be used to transform columns/fields before being synced to a client.
When filtering on parameters (token or client parameters in the case of parameter queries, and bucket parameters in the case of data queries), operators can only be used in a limited way. Typically only =
, IN
and IS NULL
are allowed on the parameters, and special limits apply when combining clauses with AND
, OR
or NOT
. The exact rules are still being refined — make sure to validate and test the Sync Rules.
When transforming output columns/fields, or filtering on row/document values, those restrictions do not apply.
If a specific operator or function is needed, please contact us so that we can consider inclusion in our roadmap.
Some fundamental restrictions on these operators and functions are:
It must be deterministic — no random or time-based functions.
No external state can be used.
It must operate on data available within a single row/document. For example, no aggregation functions allowed.
Operators
Functions
Most of these functions are based on the built-in SQLite functions and SQLite JSON functions.
Last updated