Querying & Aggregations

Add Attribute Sorting/Reorganizing to get best index for $match in aggregation and other filters (by option)

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. I have found out that the order of attributes in my (different) $match stages are relevant to the query planner of what in...

Paul Coch 4 months ago in Querying & Aggregations Will Not Implement

1 VOTE

Show latest document first instead of first document, in list

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. What would you like to see happen? Describe the desired outcome or enhancement. Why is this important to yo...

Profit Buddy AI 5 months ago in Performance & Optimization / Querying & Aggregations Future Consideration

13 VOTE

Please add support for auto-incrementing numeric IDs. For example, if an ID starts at 1000001, the next created record should automatically use 1000002

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. MongoDB lacks native support for auto-incrementing numeric IDs, forcing applications to use custom counter logic, which in...

Altaab Ansari 5 months ago in Performance & Optimization / Querying & Aggregations Future Consideration

1 VOTE

Add setOnUpdate operator for Upsert operations

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. We regularly want to upsert documents to mongo, and include a useful createdAt and updatedAt timestamp. createdAt is easy:...

WelcomeLend Operations 5 months ago in Querying & Aggregations Future Consideration

1 VOTE

MongoDB missing support for GeoJSON-compliant indexing+intersection queries

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. We are building a geospatial application that uses GeoJSON natively. We need to query MongoDB for a list of GeoJSON object...

Mitchell Horning 6 months ago in Querying & Aggregations Future Consideration

6 VOTE

Improve small collection lookup performance

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. Improved performance for lookups from large to small collections (where many origin documents match the same looked-up doc...

Ryan Peggs 8 months ago in Querying & Aggregations Future Consideration

1 VOTE

Allow descriptions for $expr sections in DB validation

What problem are you trying to solve? Focus on the what and why of the need you have, not the how you'd like it solved. Our collection has some complex $expr rules for validating our collection. Unfortunately, $expr does not allow us to add a...

Habibullah Aslam 8 months ago in Data Modeling & Indexing / Querying & Aggregations Will Not Implement

4 VOTE

Allow Pinning Query Plan Cache Key to a Fixed Plan for a Given Query Shape Hash

Allow Pinning Query Plan Cache Key to a Fixed Plan for a Given Query Shape Hash n MongoDB 8.0, the new setQuerySettings command allows administrators to enforce index hints and other behavior based on the query shape hash. This gives users partia...

Vinicius Grippa 11 months ago in Querying & Aggregations Submitted

4 VOTE

Implement a $hash operator for queries

Current State: MongoDB currently lacks a native $hash operator in the aggregation/query language. While certain helpers like convertShardKeyToHashed or $toHashedIndexKey exist, they are limited in scope: Not available as true query operators (e....

Guest 11 months ago in Querying & Aggregations Submitted

2 VOTE

Leveraging Group By/Distinct Query to use regular Index

When using Group By or Distinct queries on database, provide the ability to leverage existing index i.e these queries today will miss using existing index db.collection.distinct("field") db.collection.aggregate([ { $group: { _id: "$category", ...

Guest over 1 year ago in Querying & Aggregations Submitted

Please enter your email address

FILTER BY CATEGORY