Elasticsearch in 查询和not in 查询的实现方式

╰半橙微兮° 2022-10-28 03:54 305阅读 0赞

### in ###

POST products/_search
    {
        
      "query": {
        
        "bool": {
        
          "filter": [
            {
        
              "terms": {
        
                "product_id": ["1","2"]
              }
            }
          ]
        }
      }
    }

或是

POST products/_search
    {
        
      "query": {
        
        "bool": {
        
          "must": [
            {
        
              "terms": {
        
                "product_id": ["1","2"]
              }
            }
          ]
        }
      }
    }

### not in ###

POST products/_search
    {
        
      "query": {
        
        "bool": {
        
          "must_not": [
            {
        
              "terms": {
        
                "product_id": ["1","2"]
              }
            }
          ]
        }
      }
    }

### 示例 ###

导入数据，可以直接使用上面的查询语句测试

PUT /products
    {
        
      "mappings": {
        
        "properties": {
        
          "product_id":{
        
            "type": "keyword"
          },
          "price" : {
        
              "type" : "integer"
            },
          "date" : {
        
              "type" : "date",
              "format": "yyyy-MM-dd"
            },
          "avaliable":{
        
            "type": "boolean"
          }
        }
      }
    }
    
    POST /products/_bulk
    {
        "index":{
        "_id":1}}
    {
        "price":10,"avaliable":true,"date":"2020-12-10","product_id":"1"}
    {
        "index":{
        "_id":2}}
    {
        "price":13,"avaliable":true,"date":"2020-12-10","product_id":"2"}
    {
        "index":{
        "_id":3}}
    {
        "price":20,"avaliable":true,"date":"2020-12-10","product_id":"3"}
    {
        "index":{
        "_id":4}}
    {
        "price":30,"avaliable":true,"date":"2020-12-10","product_id":"4"}