findarray in mongodb and output to array in nodejs

Question

I have an array inside a collection in mongodb as per below.

{
"_id" : ObjectId("53dbb05fa976627439d43884"),
"employee" : [ 
    {
        "date" : "1986-03-10"

    }, 
    {
        "date" : "1986-12-11"

    }
    ]
    }

Now I want to find all distinct date and output it to array in nodejs format.

var collection = db.collection('employee');
collection.distinct('employee.date').toArray(function(err, docsa) {

console.log(docsa);

});

};

The problem is I will receive the following error, but those collection.distinct command can be run on mongodb.Anyhow I can avoid the error ?

 TypeError: Cannot call method 'toArray' of undefined

Or is there any way I can use collection.find() to get the same output?

xShirase · Accepted Answer · 2014-10-11 04:45:16Z

1

you try collection.distinct('employee.data'), on a collection called 'employee'. I believe you want :

collection.distinct('date')

edited Oct 11, 2014 at 4:45

answered Oct 11, 2014 at 4:36

xShirase

12.4k4 gold badges55 silver badges86 bronze badges

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

1 Comment

FRizal Over a year ago

opss Yes..typo error..its corrected..basically it's still the same error wrt to collection.distinct

Collectives™ on Stack Overflow

findarray in mongodb and output to array in nodejs

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