Mongo Db : elemMatch query on multiple array

Question

Please find below document structure of mongo Db

{ _id : 0,
   name : "Employee1",
   distributionList :[ { dlname : "ALLEmployee"}, {dlname:"financeall"} ],
   csrActivity : [ {activityname : "blooddonation"}, {activityname : "tree plantation"} ]

}

I want list of employee belonging to financeall distribution list and opted to volunteer tree plantation CSR activity.

Expected resultset as below

{ _id : 0,
   name : "Employee1",
   distributionList :[{dlname:"financeall"} ],
   csrActivity : [  {activityname : "tree plantation"} ]
}

But so far able to achieve below output from query

Query :

db.employee.find(
{name : "Employee1"},
{distributionList : {$eleMatch : {dlname : "financeall"}}}
)

Output :

{ _id : 0,
   name : "Employee1",
   distributionList :[{dlname:"financeall"} ]
}

Using $elemMatch to get the desired output but unable to find how to use it on multiple array within same document. Also tried certain combination but unable to get desired result.

Below query tried but not getting desired output

db.employee.find(
   {name : "Employee1"},
   {distributionList : {$eleMatch : {dlname : "financeall"}}},
   {csrActivity: {$eleMatch : {activityname : "tree plantation"}}}
)

Any help will be highly appreciated

Try db.employee.find( {name : "Employee1"}, {distributionList : {$elemMatch : {dlname : "financeall"}}, csrActivity: {$elemMatch : {activityname : "tree plantation"}}} ) — s7vr
– s7vr, Commented Sep 11, 2018 at 7:17
Already tried this query and also updated that in my question it does not work — Mahesh
– Mahesh, Commented Sep 11, 2018 at 7:19
Please take a look at the query carefully. It's not the same. — s7vr
– s7vr, Commented Sep 11, 2018 at 7:20

Simon Thiel · Accepted Answer · 2019-10-14 21:26:51Z

1

You only misspelled the projection operator $elemMatch

The correct query is:

db.employee.find(
  {
    name: "Employee1"
  }, {
    distributionList: {
        $elemMatch: {
            dlname: "financeall"
        }
    },
    csrActivity: {
        $elemMatch: {
            activityname: "tree plantation"
        }
    }
  }
)

answered Oct 14, 2019 at 21:26

Simon Thiel

3,3356 gold badges30 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

Mongo Db : elemMatch query on multiple array

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