node.js - check an array of string value with array of object in mongodb

Question

I have array of strings like this

let fromHour = ['2.5','3','3.5']
let toHour = ['2.5','3','3.5']

I have an array of object saved in mongoDB

timeRange = [
              {
                from:'2.5',
                to:'3'
              },
              {
                from:'3',
                to:'3.5'
               }

           ]

I want to check if any of my array of string value exist in that object value

I have tried this but it give me this error ( Unrecognized expression '$match' )

checkAppoint = await Appointment.aggregate([
                {
                  $project: {
                    date: myScheduleFinal[k].date,
                    status: { $in: ['pending', 'on-going'] },
                    timeRange: {
                      '$match': {
                        'from': { $in: fromHolder },
                        'to': { $in: toHolder },
                      },
                    },
                  },
                },
              ]);

also I have tried this solution and it work for me but it take to much time so I am trying this with aggregate

 checkAppoint = await Appointment.findOne({
                date: myScheduleFinal[k].date,
                status: { $in: ['pending', 'on-going'] },
                timeRange:{$elemMatch:{
                  from:{$in:fromHolder},
                  to:{$in:toHolder}
                }}
              });

So anyone have a solution for that

question from:https://stackoverflow.com/questions/65645161/check-an-array-of-string-value-with-array-of-object-in-mongodb

Answer 1

Just try $elemMatch and $in operators,

• using find() method

checkAppoint = await Appointment.find({
  timeRange: {
    $elemMatch: {
      from: { $in: fromHour },
      to: { $in: toHour }
    }
  }
})

Playground

---

• using aggregate() method

checkAppoint = await Appointment.aggregate([
  {
    $match: {
      timeRange: {
        $elemMatch: {
          from: { $in: fromHour },
          to: { $in: toHour }
        }
      }
    }
  }
])

Playground