Elasticsearch：仅包含过滤对象的嵌套字段过滤基于嵌套字段的记录

Question

我正在尝试根据嵌套字段过滤记录，并希望该数组中的匹配对象作为记录的一部分显示。 以下是我要求的详细说明。

因此，我拥有这样的elasticsearch数据：

[{
  "basicInfo": {
    "requestId": 123,
  },
  "managerInfo": {
    "manager": "John",
    
  },
  "groupInfo": [
    {
      "id": "id1",
      "name": "abc",
      "status": "Approved"
    },
    {
      "id": "id2",
      "name": "abc",
      "status": "Pending"
    }
  ]
},
{
  "basicInfo": {
    "requestId": 233,
  },
  "managerInfo": {
    "manager": "John Sr",
    
  },
  "groupInfo": [ 
    {
      "id": "id3",
      "name": "abc",
      "status": "Pending"
    }
  ]
}
]

我只想用groupInfo.status作为批准的and basicinfo.requestid AS 123过滤记录，但是我的状况是我只能在GroupInfo中获得批准的记录，而不是待定的记录。因此，我期望的输出是：

{
  "took": 23,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 3.0602708,
    "hits": [
      {
        "_index": "my_index",
        "_type": "request",
        "_id": "123",
        "_score": 3.0602708,
        "_source": {
          "basicInfo": {
            "requestId": 123
          },
          "managerInfo": {
            "manager": "John"
          },
          "groupInfo": [
            {
              "id": "id1",
              "name": "abc",
              "status": "Approved"
            }
            // No id2 here as it is in pending state
          ]
        }
      }
    ]
  }
}

但是我能够实现：

{
  "took": 23,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 3.0602708,
    "hits": [
      {
        "_index": "my_index",
        "_type": "request",
        "_id": "123",
        "_score": 3.0602708,
        "_source": {
          "basicInfo": {
            "requestId": 123
          },
          "managerInfo": {
            "manager": "John"
          },
          "groupInfo": [
            {
              "id": "id1",
              "name": "abc",
              "status": "Approved"
            },
            {
              "id": "id2",
              "name": "abc",
              "status": "Pending"
            }
          ]
        }
      }
    ]
  }
}

这是我使用的查询：

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "basicInfo.requestId": "123"
          }
        },
        {
          "nested": {
            "path": "groupInfo",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "groupInfo.status": "Approved"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}

因此，我的问题首先是我期望的，甚至可能吗？我们可以过滤结果并确保我们只从该结果获得匹配的数组吗？ 如果是，我们该怎么做？ 提前致谢。

Answer 1

也许您正在寻找。

在许多情况下，知道哪些内嵌套对象非常有用（在
嵌套的情况）或子女/家长文件（如果是
父母/孩子）导致返回某些信息。内心
命中功能可用于此功能。此功能将返回每个搜索点击
在搜索响应中
匹配不同的范围。

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "basicInfo.requestId": "123"
          }
        },
        {
          "nested": {
            "path": "groupInfo",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "groupInfo.status": "Approved"
                    }
                  }
                ]
              }
            },
            "inner_hits":{}
          }
        }
      ]
    }
  }
}