Compass
44 results found
-
I would like $match expression to not evaluate 15*24*60*60*1000 expression with the date, instead use the literal expression
When translating the following aggregation code, Compass evaluates the expression with the date. I would like to have a feature where it translates the literal expression to the available language.
Example of aggregation code:
"date": {$gte: new Date((new Date().getTime() - (15 * 24 * 60 * 60 * 1000)))}2 votes -
Make aggregate results editable
It would be great if you could update database key / values within an aggregate result, just like you can on the Documents tab.
1 vote -
Dual Scroll in Query editor
When you looking at a stage in the query builder it would be great to somehow have both sides scroll at the same time - input stage and output stage so I know that if I'm looking at doc 1 on input its also going to be doc 1 on output.
1 vote -
I would like to pass a variable or a parameter to a aggregation pipeline.
It would be beneficial to include a variable panel inside the Aggregation Pipeline tab in order to be able to pass a variable ( a parameter ) to an aggregation pipeline. In the panel I should be able to define variables and pass them by reference in an aggregation pipeline.
1 vote -
Is it possible to let the user choose when editing an aggregation whether they want it to be displayed directly at the bottom or disabled?
Is it possible to let the user choose when editing an aggregation whether they want it to be displayed directly at the bottom or disabled?
Because currently, when you open an aggregation, it automatically scrolls to the bottom, and/or if you need to search for or modify a Stage that is in the middle or at the beginning, you still have to scroll up and search for it.
If possible, give the user the option to configure this themselves: automatic scrolling to the bottom or manual scrolling.
1 vote -
aggregation pipeline save setting for limit
For aggregation pipeline settings, the ability to save and persist the chosen "Limit" setting that "Limits input documents before $group, $bucket, and $bucketAuto stages". This setting could be saved for a particular collection, or as a default setting (similar to the "General" Compass setting that can persist for "Upper Limit for maxTimeMS".
1 vote -
Improving user experience of Aggregation pipeline builder
Today, when I describe extensive aggregations, I need to use the "</> TEXT" method in the interface because it is the only way I have to comment on what each step does and to efficiently locate myself in each step. In such a way that these comments would be visually displayed before each stage in the "{} STAGES" option of the "Aggregations" tab.
It would be great if it were possible to not only comment on the steps but perhaps group them (only visually). One of the things that can be done is to use "// #regions" as it happens…
1 vote -
Add unwind as part of the Lookup it self
it's cumbersome to lookup for one document in a other collection just to write unwind after it.
it will be handy if a boolean field will return an array or object.
1 vote -
Smart Index Optimization for Aggregation Queries in Compass
When building aggregation pipelines in Compass, sometimes queries can slow down if they’re missing the right indexes or opt out.
- Creating Temporary Indexes Automatically: If the aggregation query doesn’t have an optimal index, Compass will automatically build a temporary one just for that specific operation.
- Suggesting Permanent Indexes: After running the aggregation with the temporary index, Compass will notify you and suggest saving the index permanently if it’s likely to be useful for future queries. Maybe even showing time saved with the index or without.
1 vote -
Enable us to see values of expressions in aggregation pipelines
I've got a pipeline that often does a lot of collecting and combining values. What I get out of it is wrong but I have no way of knowing which part is broken since I can't see the values its collecting and the results of its maths until the final outcome.
Could you add some sort of value reading to the aggregation pipeline builder?
1 vote -
CRUD in recursion
i have to do some operations like delete in recursion. Any operations also may be required in recursion.
1 vote -
A bug in aggregation's Wizard $lookup : It is not showing the accurate values for local & foreign fields.
A bug in aggregation's Wizard $lookup as it is not showing the accurate values for local & foreign fields. See the attached image
db.orders.insertMany([
{ "id" : 1, "item" : "almonds", "price" : 12, "quantity" : 2 },
{ "id" : 2, "item" : "pecans", "price" : 20, "quantity" : 1 },
{ "_id" : 3 }
])db.inventory.insertMany([
{ "id" : 1, "sku" : "almonds", "description": "product 1", "instock" : 120 },
{ "id" : 2, "sku" : "bread", "description": "product 2", "instock" : 80 },
{ "id" : 3, "sku" : "cashews", "description":…1 vote -
Array Function
Just like Javascript array functions such as filter, map having some option in drag and drop wizard with match and project stage will be more useful.
1 vote -
1 vote
-
Add the possibility to export a pipeline to java using Spring Data MongoDB
Spring Data for mongoDB support aggregation for use with their MongoTemplate, and it is less verbose and more readable than an aggregation to use with MongoClient.
It would be nice to be able to export a pipeline to Java language for this framework. Maybe an additional check box on the export popup.
Also, if checked, maybe replace the "Include Driver Syntax" checkbox by a "Include Spring Template syntax"
1 vote -
more aggregation pipelines are needed and most of the time if we reach above 30 pipeline its gets struck , and more hard to use
more aggregation pipelines are needed and most of the time if we reach above 30 pipeline its gets struck , and more hard to use
1 vote -
cross cluster lookup (kind of)
Hi,
This is more of an add-on request for the aggregate().Lets say we have two clusters , second clusters is derived from first cluster ( i-e some of the object ids in second cluster exist only in first cluster ).
Now I want to do a lookup for the id in the first cluster from the second cluster , which is not possible.
So , can we have another optional parameter in the aggregate function which allows us to pass the documents , over which we can apply the required stages ( i-e after using find() on cluster 2…
1 vote -
Indentation/newlines for Aggregation: Export to Language/PHP
I tried to use the the aggregation pipeline feature Export to Language, for PHP. The pipeline was quite complex, so I was surprised when I copied it into PHP Storm that the entire pipeline was on a single line, making it quite hard to read. PHP Storm will not add newlines for you when you request Code Reformatting, so the only way to make it readable was to add the newlines manually before reformatting, which is time confusing and error prone.
IMO it would be preferable if the pipeline was exported with appropriate use of newlines and indentation.
1 vote -
App Freezes on Some Aggregation Queries
When I accidentally write a $lookup pipeline query with non existing field name the application crashes. I think this bug is very annoying.
1 vote -
autosave
autosave in aggregation builder
1 vote
- Don't see your idea?