Hi, How should this expression be written as a query: ( attributes.id = 14 OR attributes.id = 15) AND ( attributes.id = 4843 OR attributes.id = 4859) The nested object looks like this: { "attributes":[ { "id":14, "type":"color", "name":"Sort", "version":1 },…

There is no single nested object in your example document that can match both must clauses of your bool query. You need a bool query with two separate nested queries. { "query": { "bool": { "must": [ { "nested": { "path": "variants.attributes", …

How to query a nested object with combined AND and OR logic?

Elastic Stack Elasticsearch

system (system) Closed November 10, 2017, 10:24am 7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Combine SHOULD/MUST condition to filter nested data Elasticsearch	1	398	July 6, 2017
Combining nested query with bool query Elasticsearch	5	35982	August 23, 2017
'And' effect search for multiple nested object Elasticsearch	2	812	January 9, 2018
Combined nested query returning wrong result Elasticsearch	2	407	December 16, 2021
Nested boolean filters on nested objects Elasticsearch	1	732	July 5, 2017

How to query a nested object with combined AND and OR logic?

Related topics