【第003篇】Elasticsearch使用说明

农户台账：查询数据来源为1且区划以**开始的

GET /homestead_household/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        },
        {
          "prefix": {
            "village_code": {
              "value": "1304"
            }
          }
        }
      ]
    }
  }
}

农户台账：查询数据来源为1且区划模糊匹配

GET /homestead_household/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        },
        {
          "wildcard": {
            "village_code": {
              "value": "1304*"
            }
          }
        }
      ]
    }
  }
}

区域台账-村级台账(村)

GET homestead_region_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "village_code": {
              "value": "130503104223"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "5"
            }
          }
        },
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        }
      ]
    }
  }
}

区域台账-村级台账(乡)

GET homestead_region_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "town_code": {
              "value": "130503104"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "5"
            }
          }
        },
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        }
      ]
    }
  }
}

区域台账-村级台账(区县)

GET homestead_region_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "county_code": {
              "value": "130503"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "5"
            }
          }
        },
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        }
      ]
    }
  }
}

区域台账-村级台账(市)

GET homestead_region_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "city_code": {
              "value": "1305"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "5"
            }
          }
        },
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        }
      ]
    }
  }
}

区域台账-村级台账(省)

GET homestead_region_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "province_code": {
              "value": "13"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "5"
            }
          }
        },
        {
          "term": {
            "datasource": {
              "value": "1"
            }
          }
        }
      ]
    }
  }
}

日增统计：查询历史日期的数据(适用于传入今天之前的日期)

GET homestead_daily_index_history/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "province_code": {
              "value": "13"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "2"
            }
          }
        },
        {
          "term": {
            "stat_date": {
              "value": "20211125"
            }
          }
        }
      ]
    }
  }
}

日增统计：查询当前日期的数据(适用于传入今天日期或不传日期)

GET homestead_daily_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "province_code": {
              "value": "13"
            }
          }
        },
        {
          "term": {
            "region_level": {
              "value": "2"
            }
          }
        }
      ]
    }
  }
}