Search query string. The syntax is 'fieldName.operation(a|o):value'.
The a|o (AND|OR) is optional and if not provided, it is considered as AND.
Additional searches can be chained with a comma.
Supported operations are:
- gt: Greater than
- lt: Less than
- gte: Greater than or equal to
- lte: Less than or equal to
- eq: Equal to
- ne: Not equal to
- ilike: Case-insensitive like
- like: Case-sensitive like
- startilike: Case-insensitive like at the start
- endilike: Case-insensitive like at the end
- startlike: Case-sensitive like at the start
- endlike: Case-sensitive like at the end
Logical operators:
- a: AND
- o: OR
Examples:
- assetRef.ilike:E62
Returns all assets with assetRef like E62
- createdAt.gte:2021-01-01
Returns all assets created after 2021-01-01
- status.eqo:PENDING,status.eqo:APPROVED
Returns all assets with status either PENDING OR APPROVED
- name.startilike:John
Returns all assets with name starting with John
- age.gtea:30,age.lt:40
Returns all assets with age greater than or equal to 30 and less than 40