Page Comparison

...

• and: Defines an array of field conditions. All entries of the array will be combined as AND.

• or: Defines an array of field conditions. All entries of the array will be combined as OR.

• field: The mandatory name of the field to select in the condition. If this field is missing in the selected JSON, this condition is ignored. If the field name is set to *, then the whole property value (JSON field names and values) will be searched by given condition. For example in order to do a “quicksearch” for a given text in all pattern selected JSON properties, you could use a condition like this:

  Code Block
  fieldName: * op: ilike value: "%searchtext%"

• op: The optional operator to apply on this condition. Can be one of:

  • = : Equals. This is the default if op parameter is is not given.

  • != : Not equals.

  • < : Lesser than.

  • > : Greater than.

  • <= : Lesser or equal than.

  • >= : Greater or equal then.

  • like : A like (contains) search by given value. You can also use % as wildcard in the value the same ways as it is used in SQL.

  • ilike : Same as like but with case-insensitive check.

  • contains : Similar to like but places % at the beginning and the end of the value so it searches for any containment. Also additional % wildcards are allowed.

  • icontains : Same as contains but searches case-insensitive.

  • in : Defines a comma separated list of values where one of it must match the field value.

  • not in : Negation of in.

• value: The value to search for. This field is mandatory.

...