MongoDB query is JSONArray instead JSONObject

Question

I want to select a whole document and send it as JSONObject.

app.post('/getinvbykost', function(request, response){ 
    var tablename = request.body.tablename; 
    Move.find({tablename: tablename}, function(err, doc) {
        response.json(doc);
    }); 
});

This gives the correct result but with "[]" ->Array and not with {} ->JSONObject. btw: I got the same issue with Move.aggregate(pipeline, function(err, res) {...

result:

[
  {
    STUFF  
  }
]

There is a function $unwind but I dont get it....

So.... respond with just the first one. doc[0] Or, use the findOne method. — user400654
– user400654, Commented Jul 23, 2015 at 19:35
Please note, there's no such thing as a JSONArray or a JSONObject, only JSON, Objects, and Arrays. doc is an array, and express converts it to JSON when sending it to the client using the res.json method. — user400654
– user400654, Commented Jul 23, 2015 at 19:36
Well, that's because #find returns an array of documents. If you need your results to be an Object with each property corresponding to some identifying data, use _.indexBy or similar code of your own. — raina77ow
– raina77ow, Commented Jul 23, 2015 at 19:37

user400654 · Accepted Answer · 2015-07-23 19:38:51Z

1

In this case since you only want one result, the findOne method would be more appropriate.

app.post('/getinvbykost', function(request, response){ 
    var tablename = request.body.tablename; 
    Move.findOne({tablename: tablename}, function(err, doc) {
        response.json(doc);
    }); 
});

answered Jul 23, 2015 at 19:38

user400654

95.1k16 gold badges168 silver badges188 bronze badges

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

8 Comments

user400654 Over a year ago

Yes, that was my comment. :)

Piet Over a year ago

I need to put a WHERE clause in it. It is right that findOne doesnt accept a WHERE-clause?

user400654 Over a year ago

the tablename: tablename is a where clause. but, yes, you can remove the callback and instead use .where and .exec

Piet Over a year ago

blind in the morning, of course, thank you Model.findOne({tablename: tablename, accepted : false}, function(err, res) {}

Piet Over a year ago

The result is a JSONObject. Why i cant push another value to it?

|

Collectives™ on Stack Overflow

MongoDB query is JSONArray instead JSONObject

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related