Geek Answers Handbook

How to use aggregation structure in MongoVUE?

Is there a way to use the aggregation structure in the latest version of mongoVUE?

The only option that looks like an aggregation structure is the GROUP option, but I could not figure out how to use it.

Can someone tell me I'm looking in the right direction? And if so, how should I write a request there.

P.S1 - It took me a while to write MapReduce in mongoVUE

P.S2 - I know how to use a shell aggregation structure.

+6
source share
2 answers

MongoVUE 1.6.1 ( released May 2, 2013 ) now includes an aggregate view. If you select a collection, you can select this view from the regular menu or the context menu of the context menu.

+6
source

Just to give an example of @Stennie's solution.

Given the following text in Mongo:

{ _id: 123456, Items: [ { Name: "Item1", Color : "Red" }, { Name: "Item2", Color : "Blue" }, { Name: "Item3", Color : "Red" } ] }

In MongueVue, by right-clicking on a collection and selecting Aggregate , you can apply a pipeline such as the following to smooth out elements, filter only red elements and re-project only element names starting from this document:

 { $match: {_id: 123456}}, { $unwind: '$Items'}, { $match: {'Items.Color': 'Red'}}, { $project: {_id: 0, Name : '$Items.Name'}}

Aggregate in MongoVue

0
source

More articles:


All Articles