mongodb query result without field name

Question

Is there a way to get mongodb query results with only the values and not the field names. My query gives me the following result:

{
           "t_number" : 2508
},
{
           "t_number" : 2560
},
{
           "t_number" : 2599
}

Ideally I want the query result to be [2508,2560,2599]. Or if that is not possible, is it possible to get the query result as [{2508},{2560},{2599}]. I know that I can iterate over the result and change the format in my programming language. I am looking for a way to get that from mongodb and save some work.

Use aggregate with $unwind. another pipeline use $group with $push. db.col.aggregate([{$unwind: "$t_number"}, {$group: {_id: field, "t_number": {$push: "$t_number"} }}]). Try it. — horacioibrahim
– horacioibrahim, Commented May 22, 2014 at 19:32
Thanks. Aggregate gives the result closer to what I am looking for. — pawinder gupta
– pawinder gupta, Commented May 23, 2014 at 2:12

mohamedrias · Accepted Answer · 2014-05-22 15:12:28Z

11

No, you can't do it directly.

But this one liner could help you:

db.collection.find({},{_id:0, t_number:1}).toArray().map(function(ele) {return ele.t_number} );

answered May 22, 2014 at 15:12

mohamedrias

18.6k3 gold badges41 silver badges47 bronze badges

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

1 Comment

Edward Over a year ago

does this result in [2508,2560,2599] being sent over the wire (as opposed to extracted application side)?

Simulant · Accepted Answer · 2014-05-22 15:08:20Z

0

I think that is not possible because mongodb returns only JSON Objects and according to http://www.json.org a JSON-Object is surrounded by curly brackets { } and (if it is not empty) a value is allways indecated by a String (and seperated by a :).

answered May 22, 2014 at 15:08

Simulant

20.2k10 gold badges68 silver badges106 bronze badges

3 Comments

Sammaye Over a year ago

MongoDB returns BSON objects

Simulant Over a year ago

Wenn that's true. BSON is a binary representation of JSON so the rules of defining a valid object are the same.

Sammaye Over a year ago

An array is an object and it is also a data type in BSON, in theory MongoDB could return a transformed result with only the array but such funcitonality does not yet exist

Collectives™ on Stack Overflow

mongodb query result without field name

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related