es sql根据字段值查询

根据id 查询

GET qes/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "_id": "2ab193d2fb4ddcd6f175d20b5769ea"
          }
        }
      ],
      "must_not": [],
      "should": []
    }
  },
  "from": 0,
  "size": 50,
  "sort": [],
  "aggs": {}
}

根据文件名称查询

GET qes/_search
{
  "query": {
    "match": {
            "file.filename": "没有bug.png"
          }
  },
  "from": 0,
  "size": 50,
  "sort": [],
  "aggs": {}
}

根据文件名称和上传时间查询

{
    "query":{
        "bool":{
            "must":[
                {
                    "match":{
                        "file.filename":"没有bug.png"
                    }
                },
                {
                    "range":{
                        "file.last_modified":{
                            "gt":"2020-12-01"
                        }
                    }
                }
            ],
            "must_not":[

            ],
            "should":[

            ]
        }
    },
    "from":0,
    "size":50,
    "sort":[

    ],
    "aggs":{

    }
}