How to populate values in array format in mongoose

Question

I have a Model structure as below in which the stage is retrieved from another model

var stageSchema = new Schema({
  Name: String,
  Stage: {
    type: Schema.ObjectId,
    ref: 'StageName',
  }
}, {
  collection: 'StageList'
});

I have written query to retrieve data using mongoose as shown below:

exports.findall = function(req, res) {
    stage.find().populate({path:'Stage',select:'-_id'}).lean().exec(function(err, value1) {
        res.send(value1);
  });
};

It displays the result as shown below

[{_id:213465465465465, Name: "AAA", Stage: {Value: "Stage1"}},{_id:213465465465465, Name: "BBB", Stage: {Value: "Stage2"}}]

But I want the Stage to be in array format without the key "Value" as shown below:

[{_id:213465465465465, Name: "AAA", Stage: ["Stage1"]},{_id:213465465465465, Name: "BBB", Stage: ["Stage2"]}]

Please help to get through this problem. Thanks in advance.

chridam · Accepted Answer · 2015-11-17 09:23:13Z

2

To modify the resulting document for Stage to be in array format without the key "Value", use JavaScript's map() method to create a new array in which you modify the objects within the array as follows:

exports.findall = function(req, res) {
    stage.find().populate({path: 'Stage', select: '-_id'}).lean().exec(function(err, results) {
        var value1 = results.map(function (r){
            var stageVal = r.Stage.Value;
            r.Stage = [stageVal];
            return r;
        });
        res.send(value1);
    });
};

answered Nov 17, 2015 at 9:23

chridam

104k26 gold badges246 silver badges243 bronze badges

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

1 Comment

chridam Over a year ago

@user3211705 No worries, happy to help :)

Collectives™ on Stack Overflow

How to populate values in array format in mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related