function reproduce(coll, indexKeyPattern, doc, filter) {
coll.drop();
coll.createIndex(indexKeyPattern);
coll.insertOne(doc);
const findCount = coll.find(filter).count();
const aggregateCount = coll.aggregate([{$match: filter}, {$count: "count"}]).toArray();
console.log('==============================================');
console.log(JSON.stringify(doc, null, 2));
console.log(findCount);
console.log(JSON.stringify(aggregateCount, null, 2));
}
const docs = [
{
_id: 269,
obj: {
obj: {
date: ISODate("2019-06-24T22:40:06.624Z"),
obj: {
_id: 273,
str: 'Zimbabwe Svalbard & Jan Mayen Islands Personal Loan Account',
date: null,
},
}
}
},
{
_id: 269,
obj: {
obj: {
date: ISODate("2019-06-24T22:40:06.624Z"),
obj: {
_id: 273,
str: 'Zimbabwe Svalbard & Jan Mayen Islands Personal Loan Account',
date: null,
array: null,
obj: {
_id: 274,
str: 'partnerships',
date: ISODate("2019-07-24T16:08:45.196Z"),
array: [],
geoJson: {type: 'Point', coordinates: [Array]},
any: 'virtual intangible Chair'
}
}
},
}
},
];
const indexKeyPattern = {
'obj.obj.date': -1,
'obj.obj.obj.$**': -1
};
const filter = {
'obj.obj.date': {'$lte': ISODate("2019-10-06T22:12:37.493Z")}
};
for (const doc of docs) {
reproduce(db.testColl, indexKeyPattern, doc, filter);
}
Major - P3