Hi, I'm trying below range query with must and should clause: Product id can range from 1 to 1000. I'm using below query to fetch product_id between 1 to 99 or product_id = 100. However I can only see the must clause executed and the result has all the records with product_id in range of 1 to 99…

Range queries with should clause not working

dadoonet (David Pilato) May 31, 2023, 12:58pm 4

Nope. Because of the must clause.

Put everything within the should array.

2 Likes

Topic		Replies	Views
Range query with should not working Elasticsearch	2	3890	May 20, 2017
Multiple range queries within "should" clause Elasticsearch elastic-stack-alerting	5	4707	March 22, 2017
Mulitiple or loop with range Elasticsearch	2	451	March 10, 2017
Bool query Elasticsearch	3	390	July 6, 2017
Range query inside another range query in ElasticSearch Elasticsearch	5	864	June 23, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Range queries with should clause not working

Related topics