[Solved] This Elasticsearch query returns no results:{"query": {"term": {"status": "Active"}}}But documents have status values like "active" (lowercase). Why? | Elasticsearch

Elasticsearch - Basics and Architecture

This Elasticsearch query returns no results:

{"query": {"term": {"status": "Active"}}}

But documents have status values like "active" (lowercase). Why?

ATerm queries are case-sensitive and require exact matches.

BThe field 'status' does not exist in the documents.

CElasticsearch does not support term queries on text fields.

DThe query syntax is incorrect.

Step-by-Step Solution

Solution:

Step 1: Understand term query behavior
Term queries are exact and case-sensitive, so "Active" differs from "active".
Step 2: Check document data
Documents have "active" lowercase, so query does not match.
Final Answer:
Term queries are case-sensitive and require exact matches. -> Option A
Quick Check:
Term query case sensitivity = D [OK]

Quick Trick: Term queries need exact case matches [OK]

Common Mistakes:

MISTAKES

Master "Basics and Architecture" in Elasticsearch

9 interactive learning modes - each teaches the same concept differently

More Elasticsearch Quizzes

This Elasticsearch query returns no results: