Currently, I am working on honing my skills in mongodb and nodejs, but have encountered a hurdle along the way. Within my mongoDB database, there is a table named Schedule containing fields such as id, start, and end. My objective is to augment the start time of a specific row by a certain duration, provided that the start time is less than the end time.
For instance, consider the following entry in the Schedule table:
{
"_id": "123",
"start": "2020-03-11T09:00:00.000Z",
"end": "2020-03-11T18:00:00.000Z"
}
Let's assume we have a duration parameter of 30 minutes (30x60x1000ms). The desired outcome is as follows:
[
{"id":1, "time":"2020-03-11T09:00:00.000Z"},
{"id":2, "time":"2020-03-11T09:30:00.000Z"},
{"id":3, "time":"2020-03-11T10:00:00.000Z"},
{"id":4, "time":"2020-03-11T10:30:00.000Z"},
{"id":5, "time":"2020-03-11T11:00:00.000Z"},
...
{"id":n, time:"2020-03-11T18:00:00.000Z}
]
I attempted to use the $add aggregation, but only managed to retrieve the first row.
const {idSchedule} = req.params;
const {duration} = req.body;
const durationMs = duration*60*1000;
console.log('duration',duration);
objId = new ObjectID(idSchedule);
Schedule.aggregate([
{ "$match":{
"_id": objId,
}
},
{ $project: { _id: 1, time: { $add: [ "$start", durationMs ] } } }
]).then((response) => {
res.send(response)
})
However, the output I received was limited to:
[
{
"_id": "5e68ebf0992e173a28e7dd46",
"time": "2020-03-11T09:30:00.000Z"
}
]
Your assistance is greatly appreciated!