The advance way how to filter records in a query.
QueryString is consist of filters joined by operators (AND, OR).
FILTER AND/OR FILTER AND/OR (FILTER AND/OR FILTER) ...
Every filter has format:
- FIELD OPERATOR VALUE
- FIELD: available query filter name (status_id, done_ration, tracker_id)
- OPERATOR:
- "=" equals
- "~" text contains
- "<=" lesser or equal
- ">=" higher or equal
- VALUE:
- a simple string: test
- a quoted string: "test test test"
- an array: [1, 2, 3]
Examples
Show all tasks which have status (New=1) or are assigned to (Test=63)
status_id = 1 OR assigned_to_id = 63
Show all tasks with status (New=1) or are assigned to (Test=63, Test2=64, Test=65) and done_ration is above 50%.
status_id = 1 OR (assigned_to_id = [63, 64, 65] AND done_ration >= 50)