Log file Viewer

[11:33:56] <kirillkh> Hi. I'm trying to use collection.watch() with pipeline that filters on fullDocument field, i.e.: {'$match': { 'operationType': 'insert', 'fullDocument.clientid': clientid }}. But I never receive any events. If I remove the filter by clientid, I receive all events properly. Have been bumping my head against the wall for two hours, can't figure it out...

[12:06:47] <kirillkh> well, it solved itself somehow...

[22:55:41] <cslcm> Hi there. I have an aggregation+lookup query: https://pastebin.com/raw/pGV0vN9J But what I really want from this is a set of unique cardInstances (so, find cardInstances which have a cardID present in giftcardHistory where the giftcardHistory entry has a specified currentOwner). I can't work out how to form this query.. any pointers?

[23:12:33] <cslcm> I'm basically looking for the equivalent of SELECT * FROM `giftcardInstances` WHERE `cardID` IN (SELECT `cardID` FROM `giftcardHistory` WHERE `currentOwner` = 'd1cd5b71-6209-4595-9bf0-771bf689ce00')