You were close. You just had the "nested" and "not" filters in the wrong order, basically.
Your (first) query says "return items that have a rating with 'ratings.rater_username' not equal to 'user1'". And so you get the first item, since it meets that requirement. What you really want to say is "return items for which all ratings have 'ratings.rater_username' not equal to 'user1'". Here is the query you want: curl -XPOST "http://localhost:9200/nestedfilters/item/_search"; -d' { "query": { "match_all": {} }, "filter": { "not": { "nested": { "path": "ratings", "filter": { "term": { "ratings.rater_username": "user1" } } } } } }' Here is a runnable example you can play with (you will need ES installed and running at localhost:9200, or supply another endpoint): http://sense.qbox.io/gist/289ceb80480db8b6574d5f879358e50c97aaf5da ----- Co-Founder and CTO, StackSearch, Inc. Hosted Elasticsearch at http://qbox.io -- View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Using-NOT-in-a-nested-filter-tp4047349p4047353.html Sent from the ElasticSearch Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1389298238074-4047353.post%40n3.nabble.com. For more options, visit https://groups.google.com/groups/opt_out.
