GET bliad7/_search { "query": {"range": { "prices.price": { "gte": 500, "lte": 600 } }} } mapping "Price" : { "type" : "nested", "properties" : { "Price" : { "type" : "double" } } },

Why this range query on nested object returns uncorrect data?

Mark_Harwood (Mark Harwood) August 28, 2019, 9:07pm 21

Logically that is correct. The document does have a price that is in the range (699).

To see only prices that match your range you’d need to also use “inner hits” in conjunction with nested query and mapping.

Topic		Replies	Views
How can i make that query? is that a nested query? Elasticsearch	2	398	June 25, 2020
Inconsistent results with range query Elasticsearch	2	522	June 22, 2019
Weird range query behavior Elasticsearch	0	435	January 15, 2018
Range search on nested object Elasticsearch	3	2057	March 21, 2013
Combination of filter and range Elasticsearch	1	268	October 13, 2021