es 7.8.1 + kibana 笔记

## 精确匹配 term
GET cms_content/_search
{
  "query": {
    "term": {
      "sort": {
        "value": 10000
      }
    }
  }
}


# 查询 排序 分页 显示字段
## match：模糊查询
## sort：排序
## form和size相当于limit的0,10
## _source：要显示哪些字段和"query"同级
GET cms_content/_search
{
    "query":{
        "match":{
            "title":"中"
        }
    },
    "sort": [
      {
        "sort": {
          "order": "asc"
        }
      }
    ],
    "from": 1000,
    "size": 10,
    "_source": ["title","describe"]
    
}


## 查询范围 range:字段名{}
### gt :: 大于
### gte:: 大于等于
### lt :: 小于
### lte:: 小于等于
GET cms_content/_count
{
  "query": {
     "range": {
            "create_time": {
              "gte": "2020-08-24T23:14:52.000Z",
              "lte": "2020-08-25T23:14:52.000Z"
            }
          }
  }
}

## 多条件查询 语法：bool:must[{},{}]
### must：and
### must_not：not
### should：or
GET cms_content/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "create_time": {
              "gte": "2020-08-24T23:14:52.000Z",
              "lte": "2020-08-25T23:14:52.000Z"
            }
          }
        },
        {
          "term": {
            "status": 1
          }
        },
        {
          "term": {
            "cid": 1
          }
        },
        {
          "term": {
            "company_id": "0a78af741cab4353aad415ce41a12476"
          }
        },
        {
          "match": {
            "title": "中"
          }
        }
      ]
    }
  }
}


## 多条件查询同一个值
GET cms_content/_count
{
  "query": {
    "multi_match": {
      "query": "中国",
      "fields": ["title","describe"]
    }
  }
}

# 正则查询以W开头后面紧跟一个0到9的数字，然后是一个或者多个其它字符
GET cms_content/_search
{
  "query": {
    "regexp": {
      "title": "W[0-9].+"
    }
  }
}

# 正则 查询以 “it” 开头的所有
GET cms_content/_search
{
  "query": {
    "regexp": {
      "title": "it.*"
    }
  },
  "_source": ["title"]
}

# 查询以 “it” 开头的所有
GET cms_content/_search
{
  "query": {
    "prefix": {
      "title": "it"
    }
  },
  "_source": ["title"]
}

# 邻近词
GET cms_content/_search
{
  "query": {
    "match_phrase": {
      "title": "中 中国"
    }
  }
}