CODEWITHSUNDEEP
node.jsmongodbasynchronousexpressmongoose
Dylan Richards
Dylan Richards

Reputation: 786

How to return multiple Mongoose collections in one get request?

I am trying to generate a response that returns the same collection sorted by 3 different columns. Here's the code I currently have:

var findRoute = router.route("/find")
findRoute.get(function(req, res) {
  Box.find(function(err, boxes) {
    res.json(boxes)
  }).sort("-itemCount");
});

As you can see, we're making a single get request, querying for the Boxes, and then sorting them by itemCount at the end. This does not work for me because the request only returns a single JSON collection that is sorted by itemCount.

What can I do if I want to return two more collections sorted by, say, name and size properties -- all in the same request?

Upvotes: 3

Views: 5184

Answers (3)

Charly
Charly

Reputation: 125

If I understand well, you want something like that : return Several collections with mongodb

Tell me if that helps.

Bye.

Upvotes: 3

Rodrigo Medeiros
Rodrigo Medeiros

Reputation: 7862

Crete an object to encapsulate the information and chain your find queries, like:

var findRoute = router.route("/find");
var json = {};

findRoute.get(function(req, res) {
  Box.find(function(err, boxes) {
    json.boxes = boxes;

    Collection2.find(function (error, coll2) {
      json.coll2 = coll2;

      Collection3.find(function (error, coll3) {
        json.coll3 = coll3;

        res.json(json);
      }).sort("-size");
    }).sort("-name");
  }).sort("-itemCount");
});

Just make sure to do the appropriate error checking.

This is kind of uggly and makes your code kind of difficult to read. Try to adapt this logic using modules like async or even promises (Q and bluebird are good examples).

Upvotes: 4

Panos
Panos

Reputation: 29

Have you tried ?

Box.find().sort("-itemCount").exec(function(err, boxes) {
    res.json(boxes)
});

Also for sorting your results based on 2 or more fields you can use :

.sort({name: 1, size: -1})

Let me know if that helps.

Upvotes: 0

Related Questions