Скачать или смотреть How to Filter Elasticsearch Documents with Composite Conditions using elasticsearch-dsl

A step-by-step guide on filtering Elasticsearch documents by type and specific conditions using the `elasticsearch-dsl` library.
---
This video is based on the question https://stackoverflow.com/q/70190816/ asked by the user 'Christinerex' ( https://stackoverflow.com/u/12559388/ ) and on the answer https://stackoverflow.com/a/70205139/ provided by the user 'ilvar' ( https://stackoverflow.com/u/1215136/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Elasticsearch DSL, filter list of objects with in list of values

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Unlocking the Power of Filtering in Elasticsearch with elasticsearch-dsl

One of the powerful features of Elasticsearch is its ability to filter complex data structures. When working with lists of objects, like locations tied to different types, knowing how to craft precise queries is crucial. In today’s guide, we will explore how to filter a list of objects within a list of values, using Python's elasticsearch-dsl library.

The Problem Explained

Suppose you have a dataset consisting of documents that look like this:

[[See Video to Reveal this Text or Code Snippet]]

In this dataset, each document has a type, a status, and an array of locations. For your application, you need to filter this data based on two conditions:

The type must be opportunity.

The location.id must be in a specified list (e.g., ["555", "456"]).

This kind of filtering can be likened to an SQL query where you would write:

[[See Video to Reveal this Text or Code Snippet]]

Crafting Your Elasticsearch Query

Using the elasticsearch-dsl library, you have multiple ways to build your query. Let's break it down into manageable parts.

Step 1: Creating the Base Query for Type

To filter for documents where the type is opportunity, you'll first create a bool query that matches this condition:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Adding Location Filters

To include the additional condition for location IDs, we'll use the terms query. You can create this part of the query as follows:

[[See Video to Reveal this Text or Code Snippet]]

Step 3: Combining Conditions

Finally, you need to combine both conditions into a single query using the bool query again. You can use either must or must_not to include or exclude items, respectively. Here’s how to achieve this in your query:

Include the Location IDs

[[See Video to Reveal this Text or Code Snippet]]

Exclude the Location IDs (optional)

If, instead, you want to exclude documents with certain location IDs, you would modify it like this:

[[See Video to Reveal this Text or Code Snippet]]

Putting It All Together

Overall, here’s a complete example that builds your Elasticsearch query seamlessly:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

In this guide, we explored how to filter Elasticsearch documents by specifying multiple conditions using elasticsearch-dsl. Whether you're matching types, filtering by IDs, or even excluding certain items, these strategies help you derive meaningful insights from your data.

By mastering such queries, you can enhance your data retrieval capabilities and streamline your application’s performance. Happy querying with Elasticsearch!