Extended $lookup

[Javier_Blanco]

To be honest, I got here from here:

Using db.collection.distinct() within the aggregation framework

I’m trying to upload information via AF query to a very fussy BI software regarding JSON format. I have trouble with a $match stage: { "$match": { "idSensor": 3, "idDevice": {"$in": db.devices.distinct("_id", {"group": DBRef("groups", 11)})} } }, This works OK with a software I use to test my queries against the server, NoSQL Booster: "idDevice": {"$in": db.devices.distinct("_id", {"group": DBRef("groups", 11)})} But not with my BI software; it rejects it …

My initial query works really fast, but I need to find an alternative syntax for "idDevice": {"$in": db.devices.distinct("_id", {"group.$id": 11})} that it is JSON-compatible.