Elasticsearch in 查询

Elasticsearch in 查询

SQL条件

select * from order
where staus in ('01', '02', '03')
1
2

DSL 查询

GET /idx_order/order/_search
{
	"query": {
		"bool": {
			"terms": {
				"status.keyword": [
					"01", "02", "03"
				]
			}
		}
	}
}
1
2
3
4
5
6
7
8
9
10
11
12

Java查询

QueryBuilder queryBuilder = QueryBuilders.termsQuery("status.keyword", new String[]{"01", "02", "03"});
1