MongoDB expression to query array of subdocuments

Question

I am building an application using MongoDB 4 / Mongoose 5.

I have a collection 'records' with an array of subdocuments 'Items'.

{
  RecordID: 1,
  Items: [
    { 
      Title: 'Example Title 1',
      Description: 'Example Description 1',
    },
    { 
      Title: 'Example Title 2',
      Description: 'Example Description 2',
    }
  ]
}

I am building a dynamic query generator that creates MongoDB expression operators based on a UI query builder. The dynamic query builder is building the MongoDB expressions correctly. However, the expressions are not working as expected when querying an array of subdocuments.

Question: Why is this expression not working for the nested array of subdocuments 'Items'?

This query works correctly.

db.records.find({ 'Items.Title': { $eq: 'Example title 1'} })

This same query as an expression is not returning any results.

db.records.find({ '$expr': { '$and': [ { '$eq': [ 'Items.Title', 'Example title 1' ] } ] }})

Also tried this:

db.records.find({ '$expr': { '$and': [ { '$eq': [ '$Items.Title', 'Example title 1' ] } ] }})

UPDATE: The query will work if updated to use $elemMatch instead. However, I need to use $expr because I am building nested queries using multiple and/or conditions which are constructed using the $expr operator. Is there any way to get this to work using $expr?

Arsen Davtyan · Accepted Answer · 2019-07-29 17:41:41Z

2

Use $elemMatch instead:

db.records.find({
    "Items" : {"$elemMatch" : {"Title" : "Example title 1"}}
})

Hope this helps.

answered Jul 29, 2019 at 17:41

Arsen Davtyan

1,9678 gold badges24 silver badges40 bronze badges

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

1 Comment

pengz Over a year ago

Thanks! The query will work if updated to use $elemMatch instead. However, I need to use $expr because I am building nested queries using multiple and/or conditions which are constructed using the $expr operator. Is there any way to get this to work using $expr?

Collectives™ on Stack Overflow

MongoDB expression to query array of subdocuments

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related