Mongodb query for condition on an array [duplicate]

Question

I have an an list of student which contain scores array of object, for example:

{
        "_id" : ObjectId("58a6c4542d0de393d2739979"),
        "student_id" : 0,
        "scores" : [
                {
                        "type" : "exam",
                        "score" : 76
                },
                {
                        "type" : "quiz",
                        "score" : 65
                },
                {
                        "type" : "homework",
                        "score" : 58
                }
        ],
        "class_id" : 438
}

I need to get student from collection, based on type and respective score with and condition for example

score greater than 60 in exam and

score greater than 50 in quiz and

score greater than 45 in homework

currently i'm trying the following query

db.students.find({$and: [{'scores.type': 'exam'}, {'scores.score': {$gt: 60}}]});

but its not working for single condition.

Any help greatly appreciated.

Nenad Vracar · Accepted Answer · 2017-03-18 11:12:30Z

1

You can create query like this using $and and then create condition for each score type using $elemMatch and $gt

{
    $and: [
        {scores: {$elemMatch: {'type': 'exam','score': {$gt: 60}}}},
        {scores: {$elemMatch: {'type': 'quiz','score': {$gt: 50}}}},
        {scores: {$elemMatch: {'type': 'homework','score': {$gt: 45}}}}
    ]
}

edited Mar 18, 2017 at 11:12

answered Mar 18, 2017 at 10:55

Nenad Vracar

122k16 gold badges160 silver badges184 bronze badges

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

Collectives™ on Stack Overflow

Mongodb query for condition on an array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related