Operators
The following operators can be used in the SQL based queries.
Number
+,-,*,/
String
+
Logic
AND, OR, NOT
=, !=, <>, >, >=, <, <=
Complex operators
SQL related
WHERE v BETWEEN a AND b
WHERE v NOT BETWEEN a AND b
WHERE v IN (10,20,30)
WHERE v NOT IN (SELECT status->indicator FROM tasks WHERE )
WHERE v >= ANY (20,30,40)
Access a child
The ->
operator is used to access nested data.
property->text
equalsproperty["text"]
in JavaScriptproperty->number
equalsproperty[number]
in JavaScriptproperty->functionName(args)
equalsproperty["functionName"](args)
in JavaScript
Object property
a -> b
a -> b -> c
Array member
a -> 1
a -> 1 -> 2
Calculated property name
a -> (1+2)
a -> ("text2 + " " + "more")
Functions
myTime -> getFullYear()
s -> substr(1,2)
Array members
WHERE tags->(0) = "work"
JavaScript string functions can also be used
WHERE description->length > 10