• Elasticsearch 6.x 的分页查询数据


     {
         "size" :3,
         "query": {
            "match" : {
                "person_name" : "张老师"
            }},
            "search_after": [1244735520000, 805649],
            "sort": [
            {"create_time": "asc"},
            {"pk": "desc"}
        ]
      }

    URL http://10.10.6.225:9200/t_resource_info/_search

    方式:POST

    返回的查询结果:

    {
      "took": 99,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "skipped": 0,
        "failed": 0
      },
      "hits": {
        "total": 1452923,
        "max_score": null,
        "hits": [
          {
            "_index": "t_resource_info",
            "_type": "doc",
            "_id": "199_805683",
            "_score": null,
            "_source": {
              "resource_format": "mp3",
              "pk": 805683,
              "structure_id": 77638,
              "person_id": 34,
              "id": "199_805683",
              "create_time": "2009-06-11 15:59:38",
              "table_name": "t_resource_info",
              "resource_type_name": "音频",
              "file_id": "C28DFAEF-904E-46C3-8119-4A78B0E337CE",
              "resource_type": 3,
              "resource_id_int": 772237,
              "@version": "1",
              "identity_id": 5,
              "area_code": 199,
              "resource_page": 0,
              "down_count": 0,
              "@timestamp": "2018-03-03T08:56:42.516Z",
              "resource_id_char": "417d63b5-4549-4012-83ba-3d33739dedf6",
              "resource_title": "最后一课",
              "type": "dsideal_db",
              "person_name": "张老师"
            },
            "sort": [
              1244735978000,
              805683
            ]
          },
          {
            "_index": "t_resource_info",
            "_type": "doc",
            "_id": "199_805700",
            "_score": null,
            "_source": {
              "resource_format": "mp3",
              "pk": 805700,
              "structure_id": 77643,
              "person_id": 34,
              "id": "199_805700",
              "create_time": "2009-06-11 16:02:22",
              "table_name": "t_resource_info",
              "resource_type_name": "音频",
              "file_id": "8CD3DA0A-63F2-4CBF-BCA6-0D14345813D5",
              "resource_type": 3,
              "resource_id_int": 772254,
              "@version": "1",
              "identity_id": 5,
              "area_code": 199,
              "resource_page": 0,
              "down_count": 0,
              "@timestamp": "2018-03-03T08:56:42.517Z",
              "resource_id_char": "c60247c3-5ab3-41b1-b772-40d24ed187a3",
              "resource_title": "最后一课",
              "type": "dsideal_db",
              "person_name": "张老师"
            },
            "sort": [
              1244736142000,
              805700
            ]
          },
          {
            "_index": "t_resource_info",
            "_type": "doc",
            "_id": "199_805719",
            "_score": null,
            "_source": {
              "resource_format": "mp3",
              "pk": 805719,
              "structure_id": 77648,
              "person_id": 34,
              "id": "199_805719",
              "create_time": "2009-06-11 16:09:18",
              "table_name": "t_resource_info",
              "resource_type_name": "音频",
              "file_id": "1F6F1D59-FF2D-43CF-B4ED-A08CB62F2943",
              "resource_type": 3,
              "resource_id_int": 772273,
              "@version": "1",
              "identity_id": 5,
              "area_code": 199,
              "resource_page": 0,
              "down_count": 0,
              "@timestamp": "2018-03-03T08:56:42.567Z",
              "resource_id_char": "c1c6fc35-aa64-4c83-9322-ef62ec82ff2d",
              "resource_title": "最后  一课",
              "type": "dsideal_db",
              "person_name": "张老师"
            },
            "sort": [
              1244736558000,
              805719
            ]
          }
        ]
      }
    }
  • 相关阅读:
    20220613 08:00:02
    20220617 08:00:01
    20220619 08:00:02
    vue3自定义指令的使用
    React中setState方法详细讲解
    js中数组reduce的使用原来这么简单
    Ant Design Vue栅格Grid的使用
    React中render Props模式
    CVE202230190 Follina Office RCE分析【附自定义word钓鱼模板POC】
    夏令营随笔
  • 原文地址:https://www.cnblogs.com/littlehb/p/8496387.html
Copyright © 2020-2023  润新知