MongoDB

db.Foo.aggregate(
  {$unwind: "$bars"},
  {$lookup: {
    from:"bar",
    localField: "bars",
    foreignField: "_id",
    as: "bar"

   }},
   {$match: {
    "bar.testprop": true
   }}
)
db.getCollection('AccountSummary').createIndex({txDate: NumberInt(1)});
db.getCollection('AccountSummary').createIndex({jobId:NumberInt(1)});
db.getCollection('AccountSummary').createIndex({userId:NumberInt(1)});
db.getCollection('AccountSummary').createIndex({isActive:NumberInt(1)});

Similiar Collections