[{"site_id":3,"status":2,"tags":[],"title":"WORTHBUY Bento Lunch Box for Kids, 2 Compartments Stainless Steel Square Lunch Box with Portable Cutlery, Portion Control Food Storage Container Leakproof, BPA Free(Pink)","total_sold_count":3,"amount_of_variations":3,"variations":[{"price":9.66,"shipping_price":0,"quantity":0,"sold_count":1,"sold_dates":[ISODate("2020-03-03T17:00:00.000Z")]},{"price":18.42,"shipping_price":0,"quantity":0,"sold_count":1,"sold_dates":[ISODate("2020-03-04T17:00:00.000Z")]},{"price":18.42,"shipping_price":0,"quantity":0,"sold_count":1,"sold_dates":[ISODate("2020-03-03T17:00:00.000Z"),ISODate("2020-03-09T20:30:56.000Z")]}]}]

db.collection.aggregate([{$match:{"variations.sold_dates":{$gt:ISODate("2020-03-05T00:00:00Z")}}},{$addFields:{"variations":{$filter:{input:"$variations",as:"variation",cond:{$gt:[{$size:{$filter:{input:"$$variation.sold_dates",cond:{$gt:["$$this",ISODate("2020-03-04T00:00:00.000Z")]}}}},0]}}}}}])