es sql根据字段值查询

系统管理员 2022-12-27 01:55 361阅读 0赞

根据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":{ 
    }
}