Mongodb find in jsonArray

Question

I would like to know for each employeeid is their list of competencyTitle from the mongodb in jsonArray below ;

{
"_id" : ObjectId("54510afa1abd8deb32e82a2e"),
"EmployeeID" : "6",
"CompetencyTitle" : "Chemical",
"Weightage" : 8
}

/* 1 */
{
"_id" : ObjectId("54510afa1abd8deb32e82a2f"),
"EmployeeID" : "6",
"CompetencyTitle" : "Biology",
"Weightage" : 6
}

 /* 2 */
{
"_id" : ObjectId("54510afa1abd8deb32e82a30"),
"EmployeeID" : "7",
"CompetencyTitle" : "Processes and Procedures",
"Weightage" : 5
 }

The output to be something like below;

EmployeeID 6 { Chemical,Biology} EmployeeID 7 {Processes and Procedures}

Neil Lunn · Accepted Answer · 2014-10-29 16:27:57Z

3

Sound basically like an aggregation framework problem. A little different in output but then again it's actually a valid structure:

db.collection.aggregate([
    { "$group": {
        "_id": "$EmployeeID",
        "competencies": { "$push": "$CompetencyTitle" }
    }}
])

Gives simple results:

{
    "_id": "6",,
    "compentencies": [ "Chemical", "Biology" ]
},
{
    "_id": "7",
    "compentencies": [ "Processes and Procedures" ]        
}

edited Oct 29, 2014 at 16:27

answered Oct 29, 2014 at 16:02

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

Collectives™ on Stack Overflow

Mongodb find in jsonArray

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related