object - 在Elasticsearch中查询具有嵌套对象的字段

Question

我有一个名为 jobdetails 的类型。该类型包含与员工的专业经验相关的详细信息。每个员工文档都具有嵌套的经验类型。

"experience": 
    {

        "type": "nested",
        "properties": 
        {
            "company": {
                "type": "string"
                   },
            "title":{
                "type": "string"
                    }
        }
    }

我想知道如何获取在其经验 Realm 仅具有“经理”或“老师”经验而没有“受训者”经验的员工。

例如:

doc 1: experience[
{“company”:“xxx”, “title”:”manager”}, 
{“company”:“xxx”, “title”:”teacher”}, 
{“company”:“xxx”, “title”:”trainee manager”},]

doc 2: experience[{“company”:“xxx”, “title”:”manager”}]

doc 3: experience[{“company”:“xxx”, “title”:”teacher”}]

doc 4: experience[
{“company”:“xxx”, “title”:”manager”},
{“company”:“xxx”, “title”:”teacher]

所需的查询应返回doc2，doc3，doc4，但不返回doc1。

Answer 1

像下面这样的查询应该可以解决问题，即我们正在寻找experience.title字段包含manager或teacher但不包含trainee的文档

{
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": [
            {
              "nested": {
                "path": "experience",
                "filter": {
                  "terms": {
                    "experience.title": [
                      "manager",
                      "teacher"
                    ]
                  }
                }
              }
            }
          ],
          "must_not": [
            {
              "nested": {
                "path": "experience",
                "filter": {
                  "terms": {
                    "experience.title": [
                      "trainee"
                    ]
                  }
                }
              }
            }
          ]
        }
      }
    }
  }
}