Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

115
Views
Mongo project test if value is in array

In a project step of a mongo aggregation, I'd like to create a boolean field like:

{
  $project: {
    isInArray: { $cond: [
      { $in: ['$_id', ids] },
      { $const: true },
      { $const: false },
    ] },
  },
},

but this is failing with

 invalid operator $in

I could not find documentation on the correct syntax

over 4 years ago · Santiago Trujillo
1 answers
Answer question

0

You can use $setIsSubset operator

db.people.aggregate([
 { $project: {
    isInArray: { $cond: [ {$setIsSubset: [['$_id'], ids]}, true, false ] }
 }}
])
over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!