Mongoose how to write a query with if condition?

Question

Suppose I have the following query: ``` post.getSpecificDateRangeJobs = function(queryData, callback) { var matchCriteria = queryData.matchCriteria; var currentDate = new Date(); var match = { expireDate: { $gte: new Date(currentDate.getFullYear(), currentDate.getMonth(), currentDate.getDate()) } }; if (queryData.matchCriteria !== "") { match = { expireDate: { $gte: new Date(currentDate.getFullYear(), currentDate.getMonth(), currentDate.getDate()) }, $text: { $search: matchCriteria } }; } var pipeline = [ { $match: match }, { $group: { _id: null, thirtyHourAgo: { $sum: { $cond: [ { $gte: [ "$publishDate", new Date(queryData.dateGroups.thirtyHourAgo) ] }, 1, 0 ] } }, fourtyEightHourAgo: { $sum: { $cond: [ { $gte: [ "$publishDate", new Date(queryData.dateGroups.fourtyHourAgo) ] }, 1, 0 ] } }, thirtyDaysAgo: { $sum: { $cond: [ { $lte: [ "$publishDate", new Date(queryData.dateGroups.oneMonthAgo) ] }, 1, 0 ] } } } } ]; var postsCollection = post.getDataSource().connector.collection( post.m…

Accepted Answer

You can use javascript to dynamically create json document based on your query parameters.

Your updated function will look something like

```
post.getSpecificDateRangeJobs = function(queryData, callback) {

var matchCriteria = queryData.matchCriteria;
  var currentDate = new Date();

// match document
  var match = {
    "expireDate": {
      "$gte": currentDate 
    }
  };

if (matchCriteria !== "") {
    match["$text"]: {
      "$search": matchCriteria
    }
  };

// group document
  var group = {
    _id: null
  };

// Logic to calculate hours difference between current date and publish date is less than 30 hours.

if (queryData.dateGroups.thirtyHourAgo) {
    group["thirtyHourAgo"] = {
      "$sum": {
        "$cond": [{
            "$lte": [{
              "$divide": [{
                "$subtract": [currentDate, "$publishDate"]
              }, 1000 * 60 * 60]
            }, 30]
          },
          1,
          0
        ]
      }
    };
  }

// Similarly add more grouping condition based on query params.

var postsCollection = post.getDataSource().connector.collection(
    post.modelName
  );

// Use aggregate builder to create aggregation pipeline.

postsCollection.aggregate()
    .match(match)
    .group(group)
    .exec(function(err, groupByRecords) {
      if (err) {
        return callback("err");
      }
      return callback(null, groupByRecords);
    });

};
```

Mongoose how to write a query with if condition?

Solution

Problem