Andspring-doc.cn
|
findByNameAndPricespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "?", "fields" : [ "name" ] } },
{ "query_string" : { "query" : "?", "fields" : [ "price" ] } }
]
}
}}spring-doc.cn
|
Orspring-doc.cn
|
findByNameOrPricespring-doc.cn
|
{ "query" : {
"bool" : {
"should" : [
{ "query_string" : { "query" : "?", "fields" : [ "name" ] } },
{ "query_string" : { "query" : "?", "fields" : [ "price" ] } }
]
}
}}spring-doc.cn
|
Isspring-doc.cn
|
findByNamespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "?", "fields" : [ "name" ] } }
]
}
}}spring-doc.cn
|
Notspring-doc.cn
|
findByNameNotspring-doc.cn
|
{ "query" : {
"bool" : {
"must_not" : [
{ "query_string" : { "query" : "?", "fields" : [ "name" ] } }
]
}
}}spring-doc.cn
|
Betweenspring-doc.cn
|
findByPriceBetweenspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : ?, "to" : ?, "include_lower" : true, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
LessThanspring-doc.cn
|
findByPriceLessThanspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : null, "to" : ?, "include_lower" : true, "include_upper" : false } } }
]
}
}}spring-doc.cn
|
LessThanEqualspring-doc.cn
|
findByPriceLessThanEqualspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : null, "to" : ?, "include_lower" : true, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
GreaterThanspring-doc.cn
|
findByPriceGreaterThanspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : ?, "to" : null, "include_lower" : false, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
GreaterThanEqualspring-doc.cn
|
findByPriceGreaterThanEqualspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : ?, "to" : null, "include_lower" : true, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
Beforespring-doc.cn
|
findByPriceBeforespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : null, "to" : ?, "include_lower" : true, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
Afterspring-doc.cn
|
findByPriceAfterspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"range" : {"price" : {"from" : ?, "to" : null, "include_lower" : true, "include_upper" : true } } }
]
}
}}spring-doc.cn
|
Likespring-doc.cn
|
findByNameLikespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "?*", "fields" : [ "name" ] }, "analyze_wildcard": true }
]
}
}}spring-doc.cn
|
StartingWithspring-doc.cn
|
findByNameStartingWithspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "?*", "fields" : [ "name" ] }, "analyze_wildcard": true }
]
}
}}spring-doc.cn
|
EndingWithspring-doc.cn
|
findByNameEndingWithspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "*?", "fields" : [ "name" ] }, "analyze_wildcard": true }
]
}
}}spring-doc.cn
|
Contains/Containingspring-doc.cn
|
findByNameContainingspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "*?*", "fields" : [ "name" ] }, "analyze_wildcard": true }
]
}
}}spring-doc.cn
|
In（当批注为 FieldType.Keyword 时）spring-doc.cn
|
findByNameIn(Collection<String>names)spring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"bool" : {"must" : [
{"terms" : {"name" : ["?","?"]}}
]
}
}
]
}
}}spring-doc.cn
|
Inspring-doc.cn
|
findByNameIn(Collection<String>names)spring-doc.cn
|
{ "query": {"bool": {"must": [{"query_string":{"query": "\"?\" \"?\"", "fields": ["name"]}}]}}}spring-doc.cn
|
NotIn（当批注为 FieldType.Keyword 时）spring-doc.cn
|
findByNameNotIn(Collection<String>names)spring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{"bool" : {"must_not" : [
{"terms" : {"name" : ["?","?"]}}
]
}
}
]
}
}}spring-doc.cn
|
NotInspring-doc.cn
|
findByNameNotIn(Collection<String>names)spring-doc.cn
|
{"query": {"bool": {"must": [{"query_string": {"query": "NOT(\"?\" \"?\")", "fields": ["name"]}}]}}}spring-doc.cn
|
Truespring-doc.cn
|
findByAvailableTruespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "true", "fields" : [ "available" ] } }
]
}
}}spring-doc.cn
|
Falsespring-doc.cn
|
findByAvailableFalsespring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "false", "fields" : [ "available" ] } }
]
}
}}spring-doc.cn
|
OrderByspring-doc.cn
|
findByAvailableTrueOrderByNameDescspring-doc.cn
|
{ "query" : {
"bool" : {
"must" : [
{ "query_string" : { "query" : "true", "fields" : [ "available" ] } }
]
}
}, "sort":[{"name":{"order":"desc"}}]
}spring-doc.cn
|
Existsspring-doc.cn
|
findByNameExistsspring-doc.cn
|
{"query":{"bool":{"must":[{"exists":{"field":"name"}}]}}}spring-doc.cn
|
IsNullspring-doc.cn
|
findByNameIsNullspring-doc.cn
|
{"query":{"bool":{"must_not":[{"exists":{"field":"name"}}]}}}spring-doc.cn
|
IsNotNullspring-doc.cn
|
findByNameIsNotNullspring-doc.cn
|
{"query":{"bool":{"must":[{"exists":{"field":"name"}}]}}}spring-doc.cn
|
IsEmptyspring-doc.cn
|
findByNameIsEmptyspring-doc.cn
|
{"query":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"name"}}],"must_not":[{"wildcard":{"name":{"wildcard":"*"}}}]}}]}}}spring-doc.cn
|
IsNotEmptyspring-doc.cn
|
findByNameIsNotEmptyspring-doc.cn
|
{"query":{"bool":{"must":[{"wildcard":{"name":{"wildcard":"*"}}}]}}}spring-doc.cn
|