[Solved] Given this bool query, which documents will be matched?{"bool": {"must": [{"term": {"category": "books"}}], "must_not": [{"term": {"status": "out_of_stock"}}]}} | Elasticsearch

Elasticsearch - Basic Search Queries

Given this bool query, which documents will be matched?

{"bool": {"must": [{"term": {"category": "books"}}], "must_not": [{"term": {"status": "out_of_stock"}}]}}

ADocuments in category 'books' and status 'out_of_stock'

BDocuments in category 'books' but not with status 'out_of_stock'

CDocuments not in category 'books' but with status 'out_of_stock'

DDocuments not in category 'books' and not with status 'out_of_stock'

Step-by-Step Solution

Solution:

Step 1: Analyze must clause
The must clause requires documents to have category equal to "books".
Step 2: Analyze must_not clause
The must_not clause excludes documents with status equal to "out_of_stock".
Final Answer:
Documents in category 'books' but not with status 'out_of_stock' -> Option B
Quick Check:
Must + must_not = include and exclude [OK]

Quick Trick: must includes, must_not excludes documents [OK]

Common Mistakes:

MISTAKES

Master "Basic Search Queries" in Elasticsearch

9 interactive learning modes - each teaches the same concept differently

More Elasticsearch Quizzes

Given this bool query, which documents will be matched?