How to make such query in mongodb?

Question

MongoDB

I need to look for either the create_date field, but if it's not there, then I'm looking for the create_time field:

Sources_Timings.find(
  {
    create_date: {
      $gte: req.body.date.starting,
      $lte: req.body.date.ending
    },
      create_time: {
        $gte: 0,
        $lte: 86400000
      }
  function(err, timings) {
                 .......
  }
)

I can of course write this easily with two queries, but this is a crutch and I think there is a way to search for fields optionally

Answer 1

you can do this https://docs.mongodb.com/manual/reference/operator... , of course, but it can be costly in terms of performance

Answer 2

$or: {
  create_date: {...}, 
  $and: { 
    create_date: { $exists: false }, 
    create_time: {...} 
  } 
}