es array nested and query
{
"query":{
"bool":{
"must":[
{
"nested":{
"path":"selfDefinefieldValueList",
"query":{
"bool":{
"must":[
{
"match":{
"selfDefinefieldValueList.code":"FormInputField_001"
}
},
{
"match":{
"selfDefinefieldValueList.value":"cece"
}
}
]
}
}
}
},
{
"nested":{
"path":"selfDefinefieldValueList",
"query":{
"bool":{
"must":[
{
"match":{
"selfDefinefieldValueList.code":"input_abc123"
}
},
{
"match":{
"selfDefinefieldValueList.value":"1"
}
}
]
}
}
}
}
],
"filter":[
]
}
}
}
查询并删除
POST company01/_delete_by_query
{
"query": {
"match": {
"message": "some message"
}
}
}
排查盘点中的异常资产
GET /xxx_sheet_record/xxxxx_sheet_record/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"inventorySheetId": {
"value": 32311,
"boost": 1
}
}
}
],
"must_not": [
{
"terms": {
"xxxxxxStatus": [
1,
10,
11,
12,
15,
50,
30,
20,
91,
21,
23,
22,
92,
110,
14,
40
],
"boost": 1
}
}
],
"adjust_pure_negative": true,
"boost": 1
}
}
}