嵌套数组的弹性搜索搜索查询

Question

{
    "application": {
        "package_name": "com.jackhenry.OregonFirstCU",
         "countries": [
            {
                "short_name": "US"
            }
         ]
},
"application": {
    "package_name": "com.jackhenry.OregonFirstCU",
    "countries": [
        {
            "short_name": "US"
        }
    ]
},
"application": {
        "package_name": "com.jackhenry.OregonFirstCU",
        "countries": [

        ]
    }
}

如何获得空数组和美国的结果application.countries和application.countries.short_name

Answer 1

简而言之，您要获取包含美国或不包含任何国家/地区名称的结果。您可以在术语和不存在之间应用应该

{
"query": {
  "bool": {
     "should": [
        {
           "bool": {
              "must_not": {
                 "exists": {
                    "field": "application.countries.short_name"
                 }
              }
           }
        },
        {
           "term": {
              "application.countries.short_name": [
                 "US"
              ]
           }
        }
     ]
   }
 }