elasticsearch 数组包含查询，匹配其中任意一个

最新推荐文章于 2025-02-23 12:49:22 发布

不做温水青蛙

最新推荐文章于 2025-02-23 12:49:22 发布

阅读量2.9k

点赞数 2

文章标签： servlet java 数据库

本文链接：https://blog.youkuaiyun.com/weixin_40442091/article/details/126288193

版权

将要匹配的字段转换成数组形式保存
mutate{
split => ["product_codes", ","]
}

GET bf_xxzx_company/_search 
{  
  "query": {
    "bool": {
      "filter": [
        {
          "terms": {
            "product_codes.keyword": [
               "SS0010130201",
                "SS0010130202",
                "CS003001",
                "ME0050010206",
                "CS003004",
                "SS001012",
                "EG002",
                "SS00102",
                "SS00105",
                "SS001011",
                "SS00106",
                "SS00103",
                "SS00104",
                "ME004003",
                "SS00100503",
                "SS00100502",
                "SS00101302"

            ]
          }
        }
      ]
    }
  }
  
}

//产品多个查询搜索
        if (!CollectionUtils.isEmpty(productCodes)){
            boolQueryBuilder.filter(QueryBuilders.termsQuery("product_codes.keyword",productCodes));
        }