ES7 Nested Sort Search

最新推荐文章于 2022-09-20 16:28:07 发布

Java般若生

最新推荐文章于 2022-09-20 16:28:07 发布

阅读量435

点赞数

分类专栏：搜索引擎文章标签： elasticsearch

本文链接：https://blog.csdn.net/linpxing1/article/details/126758673

版权

搜索引擎专栏收录该内容

3 篇文章 0 订阅

订阅专栏

ES的嵌套搜索查询 + 嵌套搜索排序实贱

POST /_search
{
   "query": {
      "nested": {
         "path": "parent",
         "query": {
            "bool": {
                "must": {"range": {"parent.age": {"gte": 21}}},
                "filter": {
                    "nested": {
                        "path": "parent.child",
                        "query": {"match": {"parent.child.name": "matt"}}
                    }
                }
            }
         }
      }
   },
   "sort" : [
      {
         "parent.child.age" : {
            "mode" :  "min",
            "order" : "asc",
            "nested": {
               "path": "parent",
               "filter": {
                  "range": {"parent.age": {"gte": 21}}
               },
               "nested": {
                  "path": "parent.child",
                  "filter": {
                     "match": {"parent.child.name": "matt"}
                  }
               }
            }
         }
      }
   ]
}

要实现Sort filter的多条件限制，如下
即 sort nested field “fitler”:{} = “query”:{}里面的内容

filter
- A filter that the inner objects inside the nested path should match
  with in order for its field values to be taken into account by
  sorting. Common case is to repeat the query / filter inside the
  nested filter or query. By default no nested_filter is active.

POST /_search
{
   "query": {
      "nested": {
         "path": "parent",
         "query": {
            "bool": {
                "must": {"range": {"parent.age": {"gte": 21}}},
                "filter": {
                    "nested": {
                        "path": "parent.child",
                        "query": {"match": {"parent.child.name": "matt"}}
                    }
                }
            }
         }
      }
   },
   "sort" : [
      {
         "parent.child.age" : {
            "mode" :  "min",
            "order" : "asc",
            "nested": {
               "path": "parent",
               "filter": {
			            "bool": {
			                "must": {"range": {"parent.age": {"gte": 21}}},
			                "filter": {
			                    "nested": {
			                        "path": "parent.child",
			                        "query": {"match": {"parent.child.name": "matt"}}
			                    }
			                }
			            }
			         }
			      },
               "nested": {
                  "path": "parent.child",
                  "filter": {
                     "match": {"parent.child.name": "matt"}
                  }
               }
            }
         }
      }
   ]
}