How can I get only objects in the sales array matching with 2021-10-14 date ? My aggregate query currently returns all objects of the sales array if at least one is matching. Dataset Documents { "name": "#0", "sales": [{ "date":…
I have one document for blogpost like this: { "_id": "5d8051cdf0b1017da7bff23c", "description": "<p>will update soon</p>", "topic": "How to setup Kafka Cluster on CentOS", "comments": [ { "created_at": "2019-10-12T02:13:01.859Z", "updated_at": "2019-10-12T02:13:01.859Z", "edited": false, "_id": "5da182aa013d12567e340a2d", "message": "test" "replies": [ { "created_at":…
I have documents that contains a tags fields. It's a simple array with tag names inside, no object nor _id inside. Just plain tags like this ["Protocol", "Access", "Leverage", "Capability"]. And in my group pipeline I tried something like 'selectedTags':…