Why are aggregations so tough in MongoDB compass? It takes so much time to use the pipeline builder to create a multi-stage aggregation. I feel it is so much easier in Robo3t. It so less fancy and so much faster. Yet somehow all my Fiverr clients use Compass.
Recently I discovered you can write aggregations in the Shell part of Compass in case you want to see the output directly. Like below.
One of my clients taught me that I can export code to a specific language too from the Compass Export option like so. It supports Java, Python, Node, and C# as of now.
I really hope they make the aggregation pipeline simpler.
Please do comment if there is an easier way of doing this. Would really help me out.
Happy programming!