Query operators
Log in to add to favouritesLogical Operators
And
This would return any document where first is 1 AND second is 2.
var query = new Query(
Op.And(
Op.EqualTo("first", 1),
Op.EqualTo("second", 2)
)
);The And operator is the default logical operator and is not required to be specified explicitly.
var query = new Query(
Op.EqualTo("first", 1),
Op.EqualTo("second", 2)
);Or
The example would return any document where first is 1 OR second is 2.
var query = new Query(
Op.Or(
Op.EqualTo("first", 1),
Op.EqualTo("second", 2)
)
);Not
The not expects an inner operator so in the example any document where first is NOT equal to 7 would be returned.
var query = new Query(
Op.Not(Op.EqualTo("first", 7))
);Relational & equality operators
Between
In this example, if our field is between 18 and 45 inclusive it would match.
var query = new Query(
Op.Between("age", 18, 45)
);Contains
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.
var query = new Query(
Op.Contains("description", "batman")
);EndsWith
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 more than 8,000 characters in that field.
var query = new Query(
Op.EndsWith("wordField", "ing")
);EqualTo
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.
var query = new Query(
Op.EqualTo("blends", 5)
);Exists
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.
var query = new Query(
Op.Exists("fieldName", true)
);FreeText
In the example the field synopsis is searched upon for any words that match gotham and dark and knight.
var query = new Query(
Op.FreeText("synopsis", "gotham dark night")
);GreaterThan
In the example any item that has a field called first and a value that is greater than 7 would be returned.
var query = new Query(
Op.GreaterThan("first", 7)
);GreaterThanOrEqualTo
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.
var query = new Query(
Op.GreaterThanOrEqualTo("first", 7)
);In
In the example any document that 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.
var query = new Query(
Op.In("first", 1, 7, 11)
);LessThan
In the example any item that has a field called first and a value that is less than 7 would be returned.
var query = new Query(
Op.LessThan("first", 7)
);LessThanOrEqualTo
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.
var query = new Query(
Op.LessThanOrEqualTo("first", 7)
);StartsWith
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 more than 8,000 characters in that field.
var query = new Query(
Op.StartsWith("name", "war")
);DistanceWithin
In the example any locations within a 10 mile radius of the specified location would match.
var query = new Query(
Op.DistanceWithin("location", 52.377, -2.749, "10mi")
);