Skip to main content1
2
3
4
5
6
7
8
9
10
11
{
"where": [{
"and": [{
"field": "first",
"equalTo": 1
}, {
"field": "second",
"equalTo": 2
}]
}]
}1
2
3
4
5
6
7
8
9
{
"where": [{
"field": "first",
"equalTo": 1
}, {
"field": "second",
"equalTo": 2
}]
}1
2
3
4
5
6
7
8
9
10
11
{
"where": [{
"or": [{
"field": "first",
"equalTo": 1
}, {
"field": "second",
"equalTo": 2
}]
}]
}1
2
3
4
5
6
7
8
{
"where": [{
"not": {
"field": "first",
"equalTo": 7
}
}]
}1
2
3
4
5
6
{
"where": [{
"field": "age",
"between": [18, 45]
}]
}1
2
3
4
5
6
{
"where": [{
"field": "description",
"contains": "batman"
}]
}1
2
3
4
5
6
{
"where": [{
"field": "description",
"contains": "batman begins"
}]
}1
2
3
4
5
6
{
"where": [{
"field": "wordField",
"endsWith": "ing"
}]
}1
2
3
4
5
6
{
"where": [{
"field": "blends",
"equalTo": 5
}]
}1
2
3
4
5
6
{
"where": [{
"field": "fieldName",
"exists": true
}]
}1
2
3
4
5
6
{
"where": [{
"field": "synopsis",
"freeText": "gotham dark knight"
}]
}1
2
3
4
5
6
7
8
9
10
11
{
"where":[
{
"field":"synopsis",
"freeText":{
"term":"gotham dark knight",
"operator":"or"
}
}
]
}1
2
3
4
5
6
7
8
9
10
11
{
"where":[
{
"field":"synopsis",
"freeText":{
"term": "gotham dark knight",
"fuzzy": true
}
}
]
}1
2
3
4
5
6
{
"where": [{
"field": "first",
"greaterThan": 7
}]
}1
2
3
4
5
6
{
"where": [{
"field": "first",
"greaterThanOrEqualTo": 7
}]
}1
2
3
4
5
6
{
"where": [{
"field": "first",
"in": [1, 7, 11]
}]
}1
2
3
4
5
6
{
"where": [{
"field": "first",
"lessThan": 7
}]
}1
2
3
4
5
6
{
"where": [{
"field": "first",
"lessThanOrEqualTo": 7
}]
}1
2
3
4
5
6
{
"where": [{
"field": "name",
"startsWith": "war"
}]
}1
2
3
4
5
6
7
8
9
10
{
"where": [{
"field": "location",
"distanceWithin": {
"lat": "52.377",
"lon": "-2.749",
"distance": "10mi"
}
}]
}