Sorting results in Elasticsearch - Mini Project: Build & Apply

Sorting Results in Elasticsearch

📖 Scenario: You are working with a collection of books stored in Elasticsearch. Each book has a title, author, and year of publication.You want to find a way to get the books sorted by their publication year, so you can see the newest books first.

🎯 Goal: Build an Elasticsearch query that sorts the books by their year field in descending order.

📋 What You'll Learn

Create an Elasticsearch query with a match_all query to get all books

Add a sort section to sort by the year field in descending order

Use the exact field name year for sorting

Print the final JSON query

💡 Why This Matters

🌍 Real World

Sorting search results is common in websites and apps to show newest, cheapest, or most relevant items first.

💼 Career

Knowing how to sort results in Elasticsearch is useful for backend developers, data engineers, and anyone working with search engines.

1

Create the base Elasticsearch query

Create a variable called query and assign it a JSON object with a query key containing a match_all query.

Elasticsearch

query = {
    "query": {
        "match_all": {}
    }
}  # Your code here

Need a hint?

The match_all query returns all documents.

2

Add sorting configuration

Add a sort key to the query dictionary. Set it to a list with one object that sorts by the year field in descending order using {"year": "desc"}.

Elasticsearch

query = {
    "query": {
        "match_all": {}
    },
    # Add sorting by year descending below
}  # Your code here

Need a hint?

The sort key takes a list of fields to sort by.

3

Use the query in a search request

Create a variable called search_request and assign it the query dictionary. This simulates preparing the search request with sorting.

Elasticsearch

search_request = query  # Your code here

Need a hint?

Assign the query to a variable to represent the search request.

4

Print the final sorted query

Print the search_request variable to display the final Elasticsearch query with sorting.

Elasticsearch

print(search_request)  # Your code here

Need a hint?

Use print(search_request) to show the query.