How to pass dynamic values to aggregate query through code?

Hello,

There are a couple of ways to achieve dynamic values in the $match stage of your aggregation pipeline, depending on the programming language you’re using:

1. Using Parameterized Queries:

This approach involves creating a template query with placeholders for the dynamic values and then filling them in before executing the query. Here’s an example (assuming JavaScript):

const objectId = "6645fe11b73219a4791ffe6c";
const startDate = new Date("2023-01-01");
const endDate = new Date("2024-12-31");

const pipeline = [
  {
    $match: {
      _id: ObjectId(objectId),
      "periodActivity.period.start": { $gte: startDate },
      "periodActivity.period.end": { $lte: endDate },
    }
  }
];

// Execute the aggregation with the dynamic values
// (This part will depend on your specific database library)
// ...

Building the Query Dynamically:

Here, you construct the entire $match stage dynamically using string manipulation or object construction:

const matchStage = {
  $match: {
    _id: ObjectId("6645fe11b73219a4791ffe6c"),
    "periodActivity.period.start": { $gte: new Date("2023-01-01") },
    "periodActivity.period.end": { $lte: new Date("2024-12-31") },
  }
};

// Modify the dynamic parts of the match stage
matchStage.$match["periodActivity.period.start"].$gte = new Date(yourStartDate);
matchStage.$match["periodActivity.period.end"].$lte = new Date(yourEndDate);

const pipeline = [matchStage];

// Execute the aggregation with the modified pipeline
// (This part will depend on your specific database library)
// ...

`
I hope the information may help you.