Log file Viewer
#mongodb logs for Thursday the 14th of January, 2021
[01:55:39] <Joaolvcm[m]> I have 2 collections(messages and actions), where both the have the field "date"(date) and "user"(objectID), and I want a count of all unique users for a timeframe on both... For now I'm doing 1 request for each collection grouping by date and getting all users ids using $addToSet, and then joining both sets in JS and counting the uniques...
[01:55:39] <Joaolvcm[m]> But is there any way to do a both collections at once, so I can i just use $addToSet and then project the $size of it instead?
[09:21:20] <chovy> i'm doing an aggregate query that gives me back docs that match something like 'topics' and 'stocks' if a doc matches on both then i get two back. i need to remove duplicates based on the 'url' property before I do the .limit(100), is that possible?
[16:30:05] <mahmoudajawad> Can someone help me find the wlmethof to use update aggregation pipeline and set the value to a string beginning with `$` sign? I tried escaping it with a backslash but that didn't work.