spring-boot - 如何在必须和必须 Elasticsearch bool 查询之间建立AND条件

Question

这是示例用户文档

{
  "id" : "1234567",
  "userId" : "testuser01",
  "firstName" : "firstname",
  "lastName" : "lastname",
  "orgId" : "567890",
  "phoneNumber" : "1234567890"
}

我想构建一个搜索查询，在其中我要拉出属于特定 orgId AND并且与用户在任何字段(userId，firstname等)中输入的搜索文本匹配的所有那些用户。

例如如果使用文本“ first ”进行搜索，我想提取所有属于特定orgId AND字段的记录，这些字段中包含 first 。

我正在尝试的示例查询是

    "query" : {
    "bool" : {
      "must" : [
        {
          "term" : {
            "orgId.keyword" : {
              "value" : "567890",
              "boost" : 1.0
            }
          }
        }
      ],
      "should" : [
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "lastName^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        },
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "userId^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        },
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "orgId^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        },
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "firstName^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        },
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "phoneNumber^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        },
        {
          "simple_query_string" : {
            "query" : "first*",
            "fields" : [
              "id^1.0"
            ],
            "flags" : -1,
            "default_operator" : "or",
            "lenient" : false,
            "analyze_wildcard" : true,
            "boost" : 1.0
          }
        }
      ],
      "disable_coord" : false,
      "adjust_pure_negative" : true,
      "boost" : 1.0
    }
  },
  "sort" : [
    {
      "userId.keyword" : {
        "order" : "asc"
      }
    }
  ]
}

我面临的问题是，我希望MUST和SHOULD之间必须有AND条件。

Answer 1

您无需为query_string查询中的每个字段指定查询。而是可以如下指定字段列表:

{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "orgId.keyword": {
              "value": "567890",
              "boost": 1
            }
          }
        },
        {
          "simple_query_string": {
            "query": "first*",
            "fields": [
              "lastName^1.0",
              "userId^1.0",
              "orgId^1.0",
              "firstName^1.0",
              "phoneNumber^1.0",
              "id^1.0"
            ]
          }
        }
      ]
    }
  },
  "sort": [
    {
      "userId.keyword": {
        "order": "asc"
      }
    }
  ]
}

也要回答

How to built AND condition between should and must elastic search bool query?

这是对此的示例查询:

{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "field1": "someval"
          }
        },
        {
          "bool": {
            "should": [
              {
                "terms": {
                  "field2": [
                    "v1",
                    "v2"
                  ]
                }
              },
              {
                "query_string": {
                  "query": "this AND that OR thus"
                }
              }
            ]
          }
        }
      ]
    }
  }
}