Computer scienceFundamentalsSQL and DatabasesDBMSMongoDBOperations and operators

Array query operations

<code>$elemMatch</code> operator

Report a typo

Suppose we have a collection named orders that contains documents with an array field items that lists the items ordered by each customer. Which of the following queries would return all the orders that have both a "shirt" item with a size "M" and a "pants" item with a size "L"?

Note: This assumes that each item in the items array has a name and size field.

Select one option from the list

db.orders.find({ items: { $elemMatch: { $and: [{ name: "shirt", size: "M" }, { name: "pants", size: "L" }] } } })

db.orders.find({ items: { $elemMatch: { name: "shirt", size: "M" }, { name: "pants", size: "L" } } })

db.orders.find({ items: { $all: ["shirt", "pants"], size: { $in: ["M", "L"] } } })

db.orders.find({ items: { $elemMatch: { $or: [{ name: "shirt", size: "M" }, { name: "pants", size: "L" }] } } })

___

Create a free account to access the full topic