Querying & Aggregations

Showing 49

Flatten arrays in group stage

Have group operators to flatten document arrays into a single one with or without repeated elements. So -> doc1 = {arr: [1,2,3,4], gr: "group"}, doc2 = {arr: [5, 6, 7, 8], gr: "group"} {$group: {_id: "$gr", arrays: {$***: "$arr"} } } => {_id...

Guest over 2 years ago in Querying & Aggregations 1 Submitted

1 VOTE

$sort should allow 0 as argument meaning "no sort"

The $sort operator and aggregation stage should allow 0 (possibly also null) as an argument for the field sort order, meaning, "Don't sort." This allows a variable to be passed in that can conditionally skip the sort operation, in addition to the ...

Guest over 1 year ago in Querying & Aggregations 0 Submitted

2 VOTE

geo

It would be nice to get the length of an LineString of a geo-json object or the possibility to write an aggregation to calculate it.

Guest over 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Feature to perform Machine Learning predictive analysis and classification in MongoDB

I want to bring the machine learning compute and predictive analysis into MongoDB atlas. Instead of ETL my data out of Atlas to achieve this, I will reduce my architectural complexity by having an aggregation operator that does this on my document...

Guest over 1 year ago in Querying & Aggregations 0 Submitted

2 VOTE

$dateDiff operator should be useful to calculate age

In the documentation it says: " For example, two dates that are 18 months apart would return 1 year difference instead of 1.5 years.". But if startDate is 2021-08-01 and endDate is 2023-02-01, the result is 2 years difference. I think it should be...

Guest almost 3 years ago in Querying & Aggregations 1 Submitted

1 VOTE

Add Relaxed mode support for the $out operator

Add Relaxed mode support for the $out operator. *and include as option in the existing drivers

Guest over 1 year ago in Querying & Aggregations 0 Submitted

1 VOTE

Aggregations should allow an empty sort stage instead of returning an error

When you run an aggregation pipeline that contains an empty sort stage (like `{"$sort": {}}`) MongoDB returns the error message "$sort stage must have at least one sort key". It would be really helpful if such a stage would work and simply not app...

Guest over 1 year ago in Querying & Aggregations 0 Submitted

2 VOTE

hint support for $graphLookup

Currently you can supply a `hint` to the `aggregation` call in order to tell MongoDB to use a specific index for the initial `$match`. But there is currently no way to specify which index to use for a `$graphLookup` later in the pipeline. I would...

Guest about 3 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Sorting support on Array fields.

Presently, I'm attempting to arrange(sort) the documents within my collection based on a key nested within an array object. However, sorting isn't functioning as expected in this scenario. A proper explanation with example is here what I mean. ht...

Guest over 1 year ago in Querying & Aggregations 0 Submitted

1 VOTE

JSON

I'm converting a lot of data for export from MongoDB -> Postgresql I would like an aggregation function to convert an object to JSON { "$addField": { "_id": true, "json": { '$convert': { 'input': '$subdocument', 'to': 'json', # // Id...

Guest over 1 year ago in Querying & Aggregations 0 Submitted

Please enter your email address

FILTER BY CATEGORY