Question

0

70

Views

How to Combine To Queries With MongoDB Operators?

I have these two search expressions. I was wandering how I could combine these two into one expression using maybe $or or $and operators using Mongoose.

Here is the code:

const mailContent = await Mail.find({ sender: id, receivers: { $elemMatch: { $eq: req.user._id } } }).populate('sender');
const outMailContent = await Mail.find({ sender: req.user._id, receivers: { $elemMatch: { $eq: id } }, type: {$not:{$eq: 'offer'}} }).populate('sender');

Thanks in advance!

7 months ago · Juan Pablo Isaza

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-07-11T14:59:08.332Z

By using $or

const mailContent = await Mail.find(
  { $or:[
    { sender: id, receivers: { $elemMatch: { $eq: req.user._id } } },
    { sender: req.user._id, receivers: { $elemMatch: { $eq: id } }, type: {$not:{$eq: 'offer'}} }
  ] }
).populate('sender');