Performing MongoDB aggregation on an array of nested objects containing date properties

Question

Performing MongoDB aggregation on an array of nested objects containing date properties

Here is a sample of the data I have:

{
  "_id": ObjectId("52ed12c144aecc4bf004d0b6"),
  "active": true,
  "name": "woslo",
 "specialDays": [
  {
  "_id": ObjectId("5f0576196198a715b0a72c14")
  "status": true
  "date": 2020-07-08T04:00:00.000+00:00
  },
  {
  "_id": ObjectId("5f05a3726198a715b0a72c94")
  "status": false
  "date": 2020-07-09T04:00:00.000+00:00
  }
 ]
}

I am trying to retrieve records using this query:

   db.serviceProviders.aggregate([
    {
      $match: {
            specialDays: {
              $elemMatch: {
                $or: [
                  {
                    $and: [
                      {
                        date:  model.date // 2020-07-09T06:00:00.000Z
                      },
                      {
                        status: true
                      }
                    ]
                  },
                  {
                    date: {
                      $ne:  model.date //2020-07-09T06:00:00.000Z
                    }
                  }
                ]
              }
            }
          }
        }
  ]);

The scenario is as follows: if the date is present in the specialDays array and the status should be true, or the date should not be in the specialDays object's array, then fetch this record. However, it keeps returning the same record even when the status is false or the date is in the array. Can you please assist me in finding a solution? I have tried multiple MongoDB Compass aggregation queries with ISODate('2020-07-08') but without success. Thank you and happy coding.

javascript mongodb date mongoose aggregation-framework

Answer 1

Answer №1

There seems to be an issue with the $ne condition in your code. When status is false, the $ne condition evaluates to true due to logical OR operation, leading to the current output.

Have you tried this solution?

db.collection.aggregate([
  {
    $match: {
      specialDays: {
        $elemMatch: {
          $or: [
            {
              $and: [
                {
                  date: new Date("2020-07-09T04:00:00.000+00:00")
                },
                {
                  status: true
                }
              ]
            },
            {
              date: {//Changes here
                $gte: new Date("2020-07-09T06:00:00.000+00:00"),
                $lte: new Date("2020-07-09T23:59:59.000+00:00")
              }
            }
          ]
        }
      }
    }
  }
])

Alternatively,

try this approach.

Another reason why your $ne condition is evaluating to true could be because it matches the first array element in the specialDays array.

db.collection.aggregate([
  {
    $match: {
      specialDays: {
        $elemMatch: {
          $or: [
            {
              $and: [
                {
                  date: new Date("2020-07-09T04:00:00.000+00:00")
                },
                {
                  status: true
                }
              ]
            },
            {
              $and: [
                {
                  date: {
                    $ne: new Date("2020-07-09T04:00:00.000+00:00")
                  }
                },
                {
                  status: false
                }
              ]
            }
          ]
        }
      }
    }
  }
])

Answer 2

There seems to be an issue with the $ne condition in your code. When status is false, the $ne condition evaluates to true due to logical OR operation, leading to the current output.

Have you tried this solution?

db.collection.aggregate([
  {
    $match: {
      specialDays: {
        $elemMatch: {
          $or: [
            {
              $and: [
                {
                  date: new Date("2020-07-09T04:00:00.000+00:00")
                },
                {
                  status: true
                }
              ]
            },
            {
              date: {//Changes here
                $gte: new Date("2020-07-09T06:00:00.000+00:00"),
                $lte: new Date("2020-07-09T23:59:59.000+00:00")
              }
            }
          ]
        }
      }
    }
  }
])

Alternatively,

try this approach.

Another reason why your $ne condition is evaluating to true could be because it matches the first array element in the specialDays array.

db.collection.aggregate([
  {
    $match: {
      specialDays: {
        $elemMatch: {
          $or: [
            {
              $and: [
                {
                  date: new Date("2020-07-09T04:00:00.000+00:00")
                },
                {
                  status: true
                }
              ]
            },
            {
              $and: [
                {
                  date: {
                    $ne: new Date("2020-07-09T04:00:00.000+00:00")
                  }
                },
                {
                  status: false
                }
              ]
            }
          ]
        }
      }
    }
  }
])

Performing MongoDB aggregation on an array of nested objects containing date properties

Answer №1

Similar questions

Troubleshooting state issues with Vuex and Firebase

How to give focus to a div in IE 8 after pressing the tab key, no jQuery required

Exploring methods to retrieve the previous item in a Dropdown list using jQuery or JavaScript

Executing Multiple Requests Concurrently in Angular 5 using forkJoin Technique

Creating a custom string subtype in TypeScript

Accessing Child HTML Elements with VueJS2

Exploiting the Benefits of Multiple BaseURLs with Require.js

Instructions on how to assign a function to a dynamically created button in Angular 2

Perform a bash command using PHP when an HTML button is clicked

AngularJs input field with a dynamic ng-model for real-time data binding

Unable to access the internal function of an Angular controller

Troubleshooting MongoDB database errors

Enhance Your Website with Bootstrap 3.0 Affix

Using React and Typescript, implement an Ant Design Table that includes a Dropdown column. This column should pass

Compiling a Chrome extension popup with background reference using Closure Compiler

Using AOS in WordPress causes the specified elements to appear as blank rather than fading in

Passing state from React.JS to a link results in an undefined props.location.state

The execution of JS code is being hindered by PHP codeigniter

The sluggishness of the comment system is attributed to the intricate layers

What is the best method to pass the URL from the browser to the backend in a Node.js environment?