Queries | ||
select | select(<property>,<property>,...) | |
Trims each object down o the set of properties defined in the arguments
|
||
values | values(<property>) | |
Returns an array of the given property value for each object
|
||
distinct | distinct() | |
Returns a result set with duplicates removed
|
||
limit | limit(count,start,maxCount) | |
Returns the given range of objects from the result set
|
||
sort | sort(<+|-><property) | |
Sorts by the given property in order specified by the prefix (+ for ascending, - for descending)
|
||
Filtering | ||
eq | eq(<property>,<value>) | |
Filters for objects where the specified property's value is equal to the provided value
|
||
ne | ne(<property>,<value>) | |
Filters for objects where the specified property's value is not equal to the provided value
|
||
lt | lt(<property>,<value>) | |
Filters for objects where the specified property's value is less than the provided value
|
||
le | le(<property>,<value>) | |
Filters for objects where the specified property's value is less than or equal to the provided value
|
||
gt | gt(<property>,<value>) | |
Filters for objects where the specified property's value is greater than the provided value
|
||
ge | ge(<property>,<value>) | |
Filters for objects where the specified property's value is greater than or equal to the provided value
|
||
in | in(<property>,<array-of-values>) | |
Filters for objects where the specified property's value is not in the provided array
|
||
out | out(<property>,<array-of-values>) | |
Filters for objects where the specified property's value is an array and the array
|
||
contains | contains(<property>,<value | expression>) | |
Filters for objects where the specified property's value is an array and the array contains any value that equals the provided value or satisfies the provided expression.
|
||
excludes | excludes(<property>,<value | expression>) | |
Filters for objects where the specified property's value is an array and the array does not contain any of value that equals the provided value or satisfies the provided expression.
|
||
rel | rel(<relation name?>,<query>) | |
Applies the provided query against the linked data of the provided relation name.
|
||
and | and(<query>,<query>,...) | |
Applies all the given queries
|
||
or | or(<query>,<query>,...) | |
The union of the given queries
|
||
Aggregating | ||
aggregate | aggregate(<property|function>,...) | |
Aggregates the array, grouping by objects that are distinct for the provided properties, and then reduces the remaining other property values using the provided functions
|
||
sum | sum(<property?>) | |
Finds the sum of every value in the array or if the property argument is provided, returns the sum of the value of property for every object in the array
|
||
mean | mean(<property?>) | |
Finds the mean of every value in the array or if the property argument is provided, returns the mean of the value of property for every object in the array
|
||
max | max(<property?>) | |
Finds the maximum of every value in the array or if the property argument is provided, returns the maximum of the value of property for every object in the array
|
||
min | min(<property?>) | |
Finds the minimum of every value in the array or if the property argument is provided, returns the minimum of the value of property for every object in the array
|
||
count | count() | |
Returns the count of the number of records in the query's result set
|
||
Misc | ||
Nested properties | ||
Any property can be nested by using an array of properties. To search by the bar property of the object in the foo property we can do: (foo,bar)=3 shorthand: foo/bar=3
|
||
Typed values | ||
foo=string:3
|
||
recurse | recurse(<property?>) | |
Recursively searches, looking in children of the object as objects in arrays in the given property value
|
||
first | first() | |
Returns the first record of the query's result set
|
||
one | one() | |
Returns the first and only record of the query's result set, or produces an error if the query's result set has more or less than one record in it.
|