Databases
StackOverflow2013
Postsdbo
POMongoDb aggregate: Select all group by x
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMongoDb aggregate: Select all group by x
    text
    copied!<p>I am trying to convert the following SQL-like statement into a mongo-query, using the new <a href="http://docs.mongodb.org/manual/applications/aggregation/" rel="noreferrer">aggregation framework</a>.</p> <pre><code>SELECT * FROM ... GROUP BY class </code></pre> <p>So far I have managed to write the following, which works well - yet only a single field is selected / returned.</p> <pre><code>db.studentMarks.aggregate( { $project: { class : 1 // Inclusion mode } }, { $group: { _id: "$class" } } ); </code></pre> <p>I have also attempted play with the $project pipelines <a href="http://docs.mongodb.org/manual/reference/aggregation/#_S_project" rel="noreferrer">exclusion mode</a>, by adding a field name which never exists, in order to trick MongoDb to return all the fields. While the syntax is correct, no results are returned. E.g:</p> <pre><code>db.studentMarks.aggregate( { $project: { noneExistingField : 0 // Exclusion mode... // Attempt to trick mongo into returning all fields // sadly this fails - empty array is returned. } }, { $group: { _id: "$class" } } ); </code></pre> <p>The reason why I need all fields to be returned, is that I will not know (in the future) what fields are going to be present or not. E.g. a "student" might have field x, y, z or not. Thus, I need to "select all", group the results by a single field and return it, for a generic purpose - doesn't have to be for "student marks", can be for any type of dataset, without knowing all the fields.</p> <p>For the mentioned reason, I cannot simply project all the fields which must be returned - once again - because I will not know all the fields.</p> <p>I hope that someone knows a good way of solving my problem, using the new aggregation framework.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload