Query operators

• And
• Or
• Not
• Between
• Contains
• endsWith
• equalTo
• Exists
• freeText
• greaterThan
• greaterThanOrEqualTo
• In
• lessThan
• lessThanOrEqualTo
• startsWith
• distanceWithin

This would return any document where first is 1 AND second is 2.

The And operator is the default logical operator and is not required to be specified explicitly.

The example would return any document where first is 1 OR second is 2.

The not expects an inner operator so in the example any document where first is NOT equal to 7 would be returned.

In this example, if our field is between 18 and 45 inclusive it would match.

This would match on a field called description containing the phrase batman. This operator can also use ? and * wildcards. However, it can be slow to search longer fields and for performance reasons it does not include entries that have more than 8,000 characters in that field. To search efficiently for complete words across the whole field use the freeText operator.

If you carried out a search with the term bat or man or batma, each of the searches would return results for batman as the terms are contained within the word.

If your description field contained the phrase batman begins, and you carried out a search containing multiple words, results would be returned for batman, batman beg, but not for batman ends.

This would find any item that has a field called wordField with a value ending with ing. Note that for performance reasons this operator does not search entries that have a text field with more than 8,000 characters in that field.

This would find any item that has a field called blends with a value exactly matching 5. For string fields, the comparison is case-insensitive. Note that for performance reasons this operator does not search entries that have a text field with more than 8,000 characters in that field.

In the example any document that has a field called fieldName and would be returned. Documents where fieldName has some content would also be returned.

You can use a value of false if you want documents that do not contain a given field or where the field is empty or null.

In the example the field synopsis is searched upon for all words that match gotham and dark and knight.

By default freeText matches all words in the search term. If you want results that match one or more words in the search term the operator can be set to "or". Results that match the most number of words in the search term are ranked higher than documents that match fewer words.

Free text searches can also be made fuzzy, by specifying fuzzy true and passing the search value as term.

A fuzzy search returns results that contain terms similar to the search term. The similarity is measured by a Levenshtein edit distance.

An edit distance is the number of one-character changes needed to turn one term into another. These changes can include:

• Changing a character (box → fox)
• Removing a character (black → lack)
• Inserting a character (sic → sick)
• Transposing two adjacent characters (act → cat)

To find similar terms, the fuzzy query creates a set of all possible variations, or expansions, of the search term within a specified edit distance. The query then returns exact matches for each expansion.

We use the preferred auto setting for fuzziness, this means that the edit distance changes dependant on the length of the search terms.

In the example any item that has a field called first and a value that is greater than 7 would be returned.

In the example any item that has a field called first and a value that is greater than or equal to 7 would be returned.

In the example any document where the field first is equal to 1,7 or 11 would be returned. The values should be of the same type, in this case integer.

In the example any item that has a field called first and a value that is less than 7 would be returned.

In the example any item that has a field called first and a value that is less than or equal to 7 would be returned.

In the example if the name field contains a value starting with war it would match. Note that for performance reasons this operator does not search entries that have a text field with more than 8,000 characters in that field.

In the example any locations within a 10 mile radius of the specified location would match.