es查询排序的写法

最新推荐文章于 2024-08-21 19:39:24 发布

xiejunna

最新推荐文章于 2024-08-21 19:39:24 发布

阅读量4w

点赞数 2

分类专栏： es 文章标签： es

本文链接：https://blog.csdn.net/xiejunna/article/details/87720274

版权

es 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

sort字段指定排序，倒序："sort": { "tftxtime": { "order": "desc" }}
查询条件格式如下：

{
	"query": {
		"bool": {
			"must": [],
			"must_not": [{
					"term": {
						"flow_yh_yh_location": ""
					}
				},
				{
					"term": {
						"routemcc": "1111"
					}
				},
				{
					"term": {
						"routemcc": "2222"
					}
				}
			],
			"should": [{
				"match_all": {}
			}]
		}
	},
	"from": 0,
	"size": 10,
	"sort": {
		"tftxtime": {
			"order": "desc"
		}
	},
	"aggs": {}
}

json压缩后：

{"query":{"bool":{"must":[],"must_not":[{"term":{"flow_yh_yh_location":""}},{"term":{"routemcc":"1111"}},{"term":{"routemcc":"2222"}}],"should":[{"match_all":{}}]}},"from":0,"size":10,"sort":{"tftxtime":{"order":"desc"}},"aggs":{}}