ES--top_hits的简单使用获取最早进最晚出的数据

xiaolin_xinji

已于 2023-07-26 18:56:50 修改

阅读量2.1k

点赞数 1

分类专栏： ElasticSearch 文章标签： top_hits elasticsearch

于 2022-04-12 19:00:00 首次发布

本文链接：https://blog.csdn.net/weixin_44131414/article/details/124122602

版权

ElasticSearch 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

该博客展示了如何使用 Elasticsearch 的 top_hits 聚合来获取指定日期范围内特定员工的最早和最晚考勤打卡记录。查询示例中，通过对 idcardno 和 record_time 进行过滤和分桶，成功地检索到了一天内员工的最早进与最晚出记录。

摘要由CSDN通过智能技术生成

需求:
业务需要知道考勤打卡记录最早进与最早出一天记录原始信息,现通过 top_hits来实现
如下:

GET /att_index/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "record_time": {
              "gte": "2022-03-07T00:00:00",
              "lte": "2022-03-08T00:00:00"
            }
          }
        },
        {
          "match":{
            "idcardno.keyword":"5*******"
          }
        }
      ]
      
    }
  }
  ,"size":0,
  "aggs": {
    "groupBy_idcardno": {
      "terms": { --对人员身份证进行分桶
        "field": "idcardno.keyword",
        "size": 50
      },
      "aggs": {
        "groupBy_recordtime":{
          "date_histogram": { --对人员打卡日期,以天为单位进行分桶
            "field": "record_time",
            "calendar_interval": "day",
            "format": "yyyy-MM-dd" ,
            "min_doc_count" : 0
          },
            "aggs": {
              "idcard_recordTime_top_last": {--通过top_hits排序获取最晚出的记录
                "top_hits": {
                  "sort": [
                    { 
                      "record_time": {
                        "order": "desc"
                      }
                    }
                  ], 
                "size": 1
                
              }
            },
            "idcard_recordTime_earliest": {--通过top_hits排序获取最早进的记录
                "top_hits": {
                  "sort": [
                    { 
                      "record_time": {
                        "order": "asc"
                      }
                    }
                  ], 
                "size": 1
                
              }
            }
          }
        }
      }
      
    }
  }

}

结果

{
  "took" : 69,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 281,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  },
  "aggregations" : {
    "record_date_partiton" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "532122*******1613",
          "doc_count" : 281,
          "groupBy_recordtime" : {
            "buckets" : [
              {
                "key_as_string" : "2022-03-07",
                "key" : 1646611200000,
                "doc_count" : 281,
                "idcard_recordTime_earliest" : {
                  "hits" : {
                    "total" : {
                      "value" : 281,
                      "relation" : "eq"
                    },
                    "max_score" : null,
                    "hits" : [
                      {
                        "_index" : "atte",
                        "_type" : "_doc",
                        "_id" : "PFywaH8BGUfFSK8ILMmm",
                        "_score" : null,
                        "_source" : {
                          
                         .....
                          "record_time" : "2022-03-07T06:04:17",
                         
                        ......
                          "idcardno" : "5*********",

                          "direct" : 1,
                        
                        },
                        "sort" : [
                          1646633057000
                        ]
                      }
                    ]
                  }
                },
                "idcard_recordTime_top_last" : {
                  "hits" : {
                    "total" : {
                      "value" : 281,
                      "relation" : "eq"
                    },
                    "max_score" : null,
                    "hits" : [
                      {
                        "_index" : "att",
                        "_type" : "_doc",
                        "_id" : "qIOSZ38BPDXhbVpyFFgY",
                        "_score" : null,
                        "_source" : {
                       .......
                          "record_time" : "2022-03-07T17:35:49",
                       ........
                          "idcardno" : "5**********",
                      ......
                          "direct" : 1,
                        
                        },
                        "sort" : [
                          1646674549000
                        ]
                      }
                    ]
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }
}