Execute an aggregation pipeline and view full results
The current Aggregation Pipeline Builder is good for authoring pipelines, but not so much for running them. The final results are limited to 20 docs and not easy to view, and viewing the intermediate stage outputs can slow down performance. There should be a way to execute a pipeline and page through the complete results.
Available in Compass 1.32
This will not be an improvement. This is jus expected!... Please also make easy to export the data just after you query it.
Also copy + paste an individual record also view the results as json not just UI tree elements.
jing xu commented
i want to export aggregation result
+1 for exporting the result
Yes! The builder is a really nice tool for writing aggregations, but it's so much hassle to have to copy the aggregation into a text editor, dig out the connection string for production and run an aggregation in code, especially if you're just answering a quick question from somebody in the business, i.e something which isn't going to live in your application code.
I spent a good 20 minutes scouring the UI thinking I was missing some hidden feature to do something with my saved pipeline. I know I can use them for views, but I thought I could run an update query via some kind of shell like feature, but this isn't supported yet.
I will suggest to add export of the results to JSON/CSV