MongoDB Query Multiple Specific Documents

Question

I would like to make a single query to my backend database to retrieve a list of results. These results will have a unique "product_id" and they will also have a "variant_id". Items may share product IDs but must have unique variant IDs. For Example

{
  product_id:"123",
  variant_id:"000"
}

{
  product_id:"123",
  variant_id:"111"
}

{
  product_id:"987",
  variant_id:"000"
}

Is it possible to write a single query that would only find

the Product with an ID of "123" and variant "000"

And the product with ID "987" and variant "000"

{
  product_id:"123",
  variant_id:"111"
}

{
  product_id:"987",
  variant_id:"000"
}

I have search this issue and only found answers related to the $in operator. but I don't think that will allow me to do what I need here? could someone point me in the right direction or let me know if this is even possible. I'm trying to avoid making individual request the the database for each item.

R2D2 · Accepted Answer · 2022-02-05 23:03:06Z

1

Simple $or can do the job:

db.collection.find({
$or: [
 {
  "product_id": "123",
  "variant_id": "000"
 },
 {
  "product_id": "987",
  "variant_id": "000"
 }
]
})

playground

answered Feb 5, 2022 at 23:03

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

3 Comments

B00100100 Over a year ago

This works in the playground but not when I use it in development?

R2D2 Over a year ago

maybe provide some more details , this is simple logical operation that is expected to work in all mongodb versions , any error messages or issues seen?

B00100100 Over a year ago

I've accepted your answer as it does what I need and opened a new question related to my specific error thanks again.

Collectives™ on Stack Overflow

MongoDB Query Multiple Specific Documents

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related