ElasticSearch term查询，时间查询，nested 子查询，filter

最新推荐文章于 2024-05-13 21:43:10 发布

jie2xiu

最新推荐文章于 2024-05-13 21:43:10 发布

阅读量240

点赞数

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

本文链接：https://blog.csdn.net/jie2xiu/article/details/131306024

版权

elasticsearch 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

term是精确查询，也就是完全匹配，通常用于对keyword和有精确值的字段进行查询，搜索前不会再对搜索词进行分词拆解

{
    "from": 0,
    "size": 10,
    "query": {
    "bool": {
      "must": [
        {
          "term": {
            "orderNo": "221075356866"
          }
        }
      ]
    }
  }
}

时间范围查询：

{
    "from": 0,
    "size": 10,
    "query": {
    "bool": {
      "must": [
        {
          "range": {
            "pubCreateDate": {
              "from": "2022-10-28 17:02:00",
              "to": "2022-10-28 17:05:00"
            }
          }
        }
      ]
    }
  }
}

nested子查询，filter

{
    "query": {
        "bool": {
            "must": [
                {
                    "nested": {
                        "path": "ccResult",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "terms": {
                                            "ccResult.alResult": [
                                                "5",
                                                "01"
                                            ]
                                        }
                                    },
                                    {
                                        "terms": {
                                            "ccResult.itemName": [
                                                "推诿",
                                                "开头语"
                                            ]
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "branchName": "北京中心"
                    }
                }
            ]
        }
    }
}