Tag: query

• Elasticsearch 8.5 scenarios to Filter on Keyword Fields Within Nested Documents Using Multi-Index Query
• MySQL query with UNION returning duplicate rows despite using DISTINCT
• MySQL 5.7: implementing using CASE statements in SELECT causing unexpected results
• Elasticsearch 8.2 scenarios to Index Nested Objects Correctly with Specific Mappings
• SQL Server: How to Optimize Performance of Complex Queries Involving Multiple Nested Subqueries
• MySQL: Unexpected behavior with JSON_ARRAY and JSON_EXTRACT in complex queries
• Django Query with Prefetch Related Returns Unexpected Results on Many-to-Many Relationship
• Elasticsearch 8.5 Aggregation with Date Range Filter Returns Unexpected Results
• Elasticsearch 8.5 implementing Custom Scoring in Function Score Query Returning Unexpected Boosts
• SQLite query with multiple IN clauses returning no rows unexpectedly
• Elasticsearch 8.5 scenarios to Handle Special Characters in Query Strings Properly
• PostgreSQL using JSONB in WHERE clause behaves unexpectedly with nested keys
• Elasticsearch 8.5 Returns Empty Results When Using Filtered Queries with Geo Distance
• LINQ Query Filtering on Multiple Conditions Leading to Unexpected Results with EF Core 6
• Django 2.2: Querying Many-to-Many Relationships with Filters - Can't Get the Desired Results
• Elasticsearch Query DSL Returning No Results Despite Matching Documents in Index
• Elasticsearch 8.5 scenarios to Retrieve Documents with Multi-Field Query Using Match
• Elasticsearch 8.5 Missing Documents in Aggregation Results with Filtered Queries
• Elasticsearch 8.5 Aggregation Returns Unexpected Bucket Counts with Date Range Filter
• Elasticsearch 8.5 Inconsistent Scoring with Custom Function Score Query
• Django ORM query returning empty instead of actual values when filtering with related fields
• Elasticsearch 8.5 Not Applying Custom Analyzer for Multi-Field Query Across Indices
• LINQ to XML - how to to Filter Nested Elements Based on Attribute Values