ES增删改查:
//查所有
GET emp_roster_8/_search
{
"query": {
"match_all":{}
}
}
//查字段为空
GET emp_roster_8/_search
{
"query": {
"bool": {
"must_not": {
"exists": {
"field": "work$empId"
}
}
}
}
}
//统计个数
GET emp_roster_8/_count
//字段值查询
GET emp_roster_8/_search
{
"query": {
"term": {
"work$workno.keyword": {
"value": "CI18043"
}
}
}
, "sort": [
{
"work$empId": {
"order": "asc"
},
"createTime": {
"order": "asc"
}
}
]
}
#根据多个id范围删除
POST /emp_roster_8/_delete_by_query
{
"query": {
"range": {
"id": {
"gte": 100000,
"lte": 200000
}
}
}
}
删除empId是1891791065241728,生效日期是1713715200000,业务类型是TERMINATION,且ID不等于1914475584151330的成长记录
{
"query": {
"bool": {
"must": [
{ "match": {"empId": "1891791065241728" }},
{ "match": {"effectiveDate": "1713715200000"}},
{ "match": {"businessEventType": "TERMINATION"}},
{
"bool": {
"must_not": [
{ "term": { "id": "1914475584151330"} }
]
}
}
]
}
}
}
在这里插入代码片