Bird
Raised Fist0
Elasticsearchquery~10 mins

Bool query (must, should, must_not, filter) in Elasticsearch - Step-by-Step Execution

Choose your learning style10 modes available
Concept Flow - Bool query (must, should, must_not, filter)
Start Bool Query
↓
Combine with OR logic
↓
Exclude matching docs
↓
Filter without scoring
↓
Return matched documents
Bool query combines multiple conditions: must (all required), should (optional), must_not (exclude), and filter (no scoring, just filter).
Execution Sample
Elasticsearch
{
  "bool": {
    "must": [{"match": {"title": "apple"}}],
    "should": [{"term": {"color": "red"}}],
    "must_not": [{"term": {"status": "sold"}}],
    "filter": [{"range": {"price": {"lte": 100}}}]
  }
}
This query finds documents with title containing 'apple', optionally red color, excludes sold items, and filters price less or equal 100.
Execution Table
StepClauseConditionEvaluationEffect on Results
1musttitle contains 'apple'Check if document title has 'apple'Include only if true
2shouldcolor is 'red'Check if document color is 'red'Boost score if true, but not required
3must_notstatus is 'sold'Check if document status is 'sold'Exclude document if true
4filterprice <= 100Check if price is less or equal 100Include only if true, no score change
5finalCombine all clausesDocuments must pass must and filter, must_not excludes, should boosts scoreReturn matching documents
💡 Documents not matching must or filter clauses or matching must_not are excluded; should clauses influence scoring but do not exclude.
Variable Tracker
VariableStartAfter Step 1After Step 2After Step 3After Step 4Final
DocumentsAll documentsOnly with title 'apple'Same set, score boosted if color 'red'Exclude those with status 'sold'Only with price <= 100Final filtered and scored documents
Key Moments - 3 Insights
Why do documents that don't match 'should' clauses still appear in results?
Because 'should' clauses boost score but are not required; only 'must' and 'filter' clauses strictly include documents (see execution_table step 2).
Does 'filter' affect document scoring?
'Filter' clauses only include or exclude documents without changing their score, unlike 'must' or 'should' (see execution_table step 4).
What happens if a document matches a 'must_not' clause?
It is excluded from results regardless of other matches (see execution_table step 3).
Visual Quiz - 3 Questions
Test your understanding
According to the execution_table, what happens at step 3?
A'must_not' boosts document score
BDocuments matching 'must_not' are included
CDocuments matching 'must_not' are excluded
D'must_not' filters documents without exclusion
💡 Hint
Check execution_table row with Step 3 describing 'must_not' clause effect
Looking at variable_tracker, what is the state of documents after step 4?
ADocuments filtered to price <= 100
BDocuments boosted by 'should' clause
CDocuments with price > 100 included
DDocuments excluded by 'must_not' clause
💡 Hint
See variable_tracker column 'After Step 4' describing price filtering
If we remove the 'must' clause, how does the execution_table change?
A'must_not' clause becomes required
B'must' step is skipped, documents no longer required to have title 'apple'
C'should' clause excludes documents
D'filter' clause boosts scores
💡 Hint
Refer to execution_table step 1 about 'must' clause requirement
Concept Snapshot
Bool query syntax:
{
  "bool": {
    "must": [...],
    "should": [...],
    "must_not": [...],
    "filter": [...]
  }
}

Behavior:
- must: required conditions
- should: optional, boosts score
- must_not: excludes matches
- filter: filters without scoring

Use to combine multiple query parts logically.
Full Transcript
A Bool query in Elasticsearch combines multiple conditions to find documents. The 'must' clause requires documents to match all its conditions. The 'should' clause adds optional conditions that boost document scores but do not exclude documents if not matched. The 'must_not' clause excludes documents that match its conditions. The 'filter' clause filters documents without affecting their score. Execution proceeds by checking each clause in order: first 'must', then 'should', then 'must_not', and finally 'filter'. Documents must pass 'must' and 'filter' clauses, must not match 'must_not', and may match 'should' to improve ranking. This combination allows flexible and powerful searches.

Practice

(1/5)
1. Which clause in an Elasticsearch bool query is used to exclude documents that match a condition?
easy
A. must
B. must_not
C. should
D. filter

Solution

  1. Step 1: Understand bool query clauses

    The bool query has four main clauses: must (required), should (optional), must_not (exclude), and filter (limit without scoring).
  2. Step 2: Identify exclusion clause

    The must_not clause excludes documents that match its conditions from the results.
  3. Final Answer:

    must_not -> Option B
  4. Quick Check:

    Exclude = must_not [OK]
Hint: Exclude with must_not clause in bool query [OK]
Common Mistakes:
  • Confusing must_not with must
  • Using should to exclude documents
  • Thinking filter excludes documents
2. Which of the following is the correct syntax to add a must clause inside a bool query in Elasticsearch?
easy
A. "bool": { "must": [ { "match": { "field": "value" } } ] }
B. "bool": { "must": ( { "match": { "field": "value" } } ) }
C. "bool": { "must": "match": { "field": "value" } }
D. "bool": { "must": { "match": { "field": "value" } } }

Solution

  1. Step 1: Recall bool must clause syntax

    The must clause expects an array of query objects inside the bool query.
  2. Step 2: Check each option's syntax

    "bool": { "must": [ { "match": { "field": "value" } } ] } correctly uses an array with one match query object. The other options use incorrect types or missing brackets.
  3. Final Answer:

    "bool": { "must": [ { "match": { "field": "value" } } ] } -> Option A
  4. Quick Check:

    Must clause = array of queries [OK]
Hint: Must clause requires an array of query objects [OK]
Common Mistakes:
  • Using object instead of array for must
  • Missing brackets around match query
  • Using parentheses instead of brackets
3. Given this bool query snippet, which documents will be matched?
{
  "bool": {
    "must": [{ "term": { "status": "active" }}],
    "should": [{ "term": { "role": "admin" }}],
    "must_not": [{ "term": { "banned": true }}]
  }
}
medium
A. Documents with status 'active' and role 'admin', excluding banned ones
B. Documents with status 'active' or role 'admin', including banned ones
C. Documents with role 'admin' only, excluding banned ones
D. Documents with status 'active', optionally role 'admin', excluding banned ones

Solution

  1. Step 1: Analyze must clause effect

    The must clause requires documents to have status: active.
  2. Step 2: Analyze should and must_not clauses

    The should clause means documents with role: admin are preferred but not required. The must_not clause excludes documents where banned is true.
  3. Final Answer:

    Documents with status 'active', optionally role 'admin', excluding banned ones -> Option D
  4. Quick Check:

    Must + optional should + exclude must_not = Documents with status 'active', optionally role 'admin', excluding banned ones [OK]
Hint: Must is required, should is optional, must_not excludes [OK]
Common Mistakes:
  • Thinking should is required
  • Ignoring must_not exclusion
  • Confusing must and should roles
4. Identify the error in this bool query:
{
  "bool": {
    "must": { "match": { "title": "Elasticsearch" } },
    "filter": { "term": { "status": "published" } },
    "must_not": [ { "term": { "archived": true } } ]
  }
}
medium
A. "must" should be an array, not an object
B. "filter" cannot be used with "must_not"
C. "must_not" should be an object, not an array
D. The query is correct as is

Solution

  1. Step 1: Check must clause format

    The must clause expects an array of query objects, but here it is given as a single object.
  2. Step 2: Validate other clauses

    The filter and must_not clauses are correctly formatted as an object and an array respectively.
  3. Final Answer:

    "must" should be an array, not an object -> Option A
  4. Quick Check:

    Must clause = array required [OK]
Hint: Must clause must always be an array [OK]
Common Mistakes:
  • Using object instead of array for must
  • Thinking filter and must_not conflict
  • Using array for must_not incorrectly
5. You want to find documents where the category is 'books' and the price is less than 20, but exclude those that are out of stock. Which bool query correctly implements this?
hard
A. { "bool": { "should": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": [ { "term": { "stock": "out" } } ] } }
B. { "bool": { "filter": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": { "term": { "stock": "out" } } } }
C. { "bool": { "must": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": [ { "term": { "stock": "out" } } ] } }
D. { "bool": { "must": { "term": { "category": "books" } }, "filter": { "range": { "price": { "lt": 20 } } }, "must_not": [ { "term": { "stock": "out" } } ] } }

Solution

  1. Step 1: Identify required conditions

    Documents must have category: books and price < 20. Both are required, so they go in must as an array.
  2. Step 2: Exclude out of stock documents

    Documents with stock: out must be excluded, so use must_not with an array of term queries.
  3. Step 3: Check each option

    { "bool": { "must": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": [ { "term": { "stock": "out" } } ] } } correctly uses must array for required conditions and must_not array for exclusion. { "bool": { "filter": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": { "term": { "stock": "out" } } } } uses filter which is okay but must_not is an object, not array. { "bool": { "should": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": [ { "term": { "stock": "out" } } ] } } uses should which makes conditions optional, wrong here. { "bool": { "must": { "term": { "category": "books" } }, "filter": { "range": { "price": { "lt": 20 } } }, "must_not": [ { "term": { "stock": "out" } } ] } } uses must as object and filter as object, mixing styles incorrectly.
  4. Final Answer:

    { "bool": { "must": [ { "term": { "category": "books" } }, { "range": { "price": { "lt": 20 } } } ], "must_not": [ { "term": { "stock": "out" } } ] } } -> Option C
  5. Quick Check:

    Must array + must_not array for exclusion [OK]
Hint: Use must array for required, must_not array to exclude [OK]
Common Mistakes:
  • Using should instead of must for required filters
  • Using object instead of array for must or must_not
  • Mixing filter and must incorrectly
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard