parse-server: Aggregation match doesn't seem to work with date value

There is another work-around :

{
    'match': {
        "$expr": {
            "$lte": [
                "$some_date_field", 
                {
                    "$toDate": "2020-09-09T00:00:00.000Z" 
                }
            ]
        }
    }
}

Where “2020-09-09T00:00:00.000Z” can be used as string. Hope it helps someone till the fix will be available in the following releases.

Thanks for the workaround @adrianaxente

Sorry guys been off the grid.

I’ll submit a PR sometime this week.

extracting databaseController adapter is my workaround.

Parse.Cloud.define(“testMongoAggregate”, function(request, response) { // const { val1, val2 } = request.params; const { AppCache } = require(“parse-server/lib/cache”); // this refrenese only in cloud cloud const app = AppCache.get(process.env.APP_ID);

const schema = { // you don’t have to write all specifics here, but have to have fields object. fields: {} };

const start = moment.utc().startOf(‘day’); // Start of day const end = moment.utc().endOf(‘day’); // End of day

const pipeline = [ { $match: { _created_at: { $lte: new Date(‘2018-04-11T00:00:00.000Z’), $gte: new Date(‘2018-04-01T00:00:00.000Z’) }, } }, { $sort: { _created_at: -1 } }, { $group: { _id: “$_p_project” } } ];

app.databaseController.adapter .aggregate(“Table”, schema, pipeline) .then(result => { console.log(result); if (result) { response.success({ success: result }); } else { response.error({ error: true }); } }); });