Return an array of values as a result

Question

I am querying a MongoDB database from a shell, I have a query that returns documents:

{"events" : "A"}
{"events" : "B"}
{"events" : "C"}
{"events" : "C"}

I would like to format the return to just return the values like so:

{"events" : [A, B, C, C]}

Mani · Accepted Answer · 2019-04-20 20:08:07Z

2

$group can be used to get your expected result.

db.collection.aggregate(
   [
      {
        $group : {
           _id : null,
           events: { $push: "$events" }
        }
      }
   ]
)

answered Apr 20, 2019 at 20:08

Mani

1,5371 gold badge13 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you, I just couldn't figure out how to group duplicate values.