[{"GroupName":"test-loadtime-changes","MasterTemplateName":"Test_horizontal_comp","MasterDraftTemplateName":"Test_horizontal_comp","DraftUrls":[{"IncomingUrl":"/test2/test-loadtime-changes----anaa----aaa","Status":"Active","Config":[{"ConfigName":"originCityName","ConfigValue":"ANAA"},{"ConfigName":"destCityName","ConfigValue":"ANAA"},{"ConfigName":"originCityCode","ConfigValue":"AAA"},{"ConfigName":"destCityCode","ConfigValue":"AAA"}],"Indexing":false}],"Urls":[{"IncomingUrl":"/test2/test-loadtime-changes----anaa----aaa","Status":"Active","Config":[{"ConfigName":"originCityName","ConfigValue":"ANAA"},{"ConfigName":"destCityName","ConfigValue":"ANAA"},{"ConfigName":"originCityCode","ConfigValue":"AAA"},{"ConfigName":"destCityCode","ConfigValue":"AAA"}],"Indexing":false}]}]

db.collection.aggregate([{$match:{GroupName:"test-loadtime-changes"}},{$addFields:{filteredUrls:{$filter:{input:"$DraftUrls",cond:{$or:[{$eq:["$$this.Status","Inactive"]},{$and:[{$eq:["$$this.Status","Validity"]},{$gte:["$$this.Validity",new Date()]}]}]}}}}}])