CODEWITHSUNDEEP
mongodb
Matt
Matt

Reputation: 361

Return an array of values as a result

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]}

Upvotes: 0

Views: 50

Answers (1)

Mani
Mani

Reputation: 1549

$group can be used to get your expected result.

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

Upvotes: 2

Related Questions