Submersible

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]

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)