SiRQL 1.3.1

Structure

A condition is always structured by following pattern:

field_name = operator(param1, param2, …)

Less than (lt)

Compares the field value to the parameter and returns True if the field value is lower then the parameter.

http://example/data/find?age=lt(10)

Greater than (gt)

Compares the field value to the parameter and returns True if the field value is higher then the parameter.

http://example/data/find?age=gt(10)

Between (between)

Compares the field value to the parameters and returns True if the field value is higher than the first parameter and lower than the second parameter.

http://example/data/find?age=between(5, 10)

Equals to (eq)

Compares the field value to the parameters and returns True if the field value matches one of the parameters exactly.

Usually only one parameter is used:

http://example/data/find?name=eq("Florian")

It is possible to add multiple parameters which could match:

http://example/data/find?name=eq("Florian", "Manuel")

Results in a query like:

if name is "Florian" OR "Manuel"

Like (like)

Compares the field value to the parameter and returns True if the field value matches the parameter.

Wildcards like % can be used in the parameter string:

http://example/data/find?name=like("Flo%")

Is (is)

Returns True if the field value matches the given type.

http://example/data/find?name=is(NULL)
http://example/data/find?name=is(FALSE)
http://example/data/find?name=is(TRUE)

Negation (not)

To negate an operator it is possible to use not_ as operator prefix. With the not_ prefix the result of the expression will be negated.

This will match all values which are not Florian:

http://example/data/find?name=not_eq("Florian")

Other examples:

http://example/data/find?is_happy=not_is(True)
http://example/data/find?age=not_gt(10)
http://example/data/find?age=not_between(5, 10)

Contains (contains)

Returns True if the first parameter does exist in the field. This methods does only work for JSON fields.

http://example/data/find?data=contains("time")

String Escaping

http://example/data/find?comment=eq("hello \"world\"")

http://example/data/find?comment=eq("hello \\ world")