$expr not using indices

[Patrick_DEMONGUERES]

Thanks! I opened a similar post few days ago, and here the workaround found :

Aggregation with indexed date field not working

Here is the steps to rewrite the pipeline : create a collection named workaround insert documents with the value you want to use : {_id:"1h", ms:3600000} {_id:"1d", ms:86400000} {_id:"4d", ms:345600000} rewrite your pipeline from the workaround collection, with this stages ** stage 1 : $match to target your duration (4d? 1h?) ** stage 2 : $project to calculate your threashold date from $subtract and $$NOW ** stage 3 : $lookup to build a _tmp array, from stage 2 and the main collection. U…