I have three objects, two of them has value in deletedAt
field (Date).
const pipeline = [
{
match: {
status: statuses.checked,
promotion: { $eq: `Promotion$${promotionId}` },
// deletedAt: { $exists: false },
// deletedAt: { $exists: true },
// deletedAt: { $eq: null },
}
},
{ group: { objectId: null, averageRating: { $avg: '$rating' }, reviewsQty: { $sum: 1 } } },
];
const ratingResult = await PromotionReview.getQuery().aggregate(pipeline, { useMasterKey: true });
has output:
ratingResult = [ { averageRating: 3.3333333333333335, reviewsQty: 3, objectId: null } ]
If uncomment deletedAt: { $exists: false }
or deletedAt: { $exists: true }
I’ll get the same output:
ratingResult = [ { averageRating: 3, reviewsQty: 2, objectId: null } ]
If uncomment deletedAt: { $eq: null }
I’ll get an empty result:
ratingResult = []
parse-server: 3.6.0.