Collection of field names, conditions, and values used to filter the query.
See Filters and Conditions Reference for help.
List of field names accepted:
createdDate
(gt, ge, lt, le, eq, ne)
name
(ne, eq, ct, nct)
email
(ne, eq, ct, nct)
status
(in, nin, eq, ne)
role.xxx
(ne, eq, ct, nct) where xxx is the role field: roleLabel or roleValue
List of comparison accepted - enclosed between parentheses:
eq
or empty => equal
gt
=> greater than
ge
=> greater or equal
lt
=> less than
le
=> less or equal
ne
=> not equal
ct
=> contains
nct
=> not contains
in
=> inside array separated by ”|”
nin
=> not inside array separated by ”|”
List of parameters accepted:
limitRecord
: max number of records for query (default=“20”, “0” or negative value for all)
fromRecord
: initial record in query
Example: name(ct)=john
return all records with name containing ‘john’