[SERVER-79282] Cannot group using searchMeta Created: 25/Jul/23 Updated: 09/Oct/23 Resolved: 09/Oct/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | ahmad al sharbaji | Assignee: | Noopur Gupta |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Server Triage
|
| Participants: |
| Description |
|
My documents are like this below:
I have more than 50M documents, and $searchMeta saved my life with its faceting speed! But, it's not complete. Please help me to achieve it. I wanna count documents based on aff and src grouping. And ts and st as filters. And getting the maximum date for every group. I developed this aggregation pipeline below:
The output of this is like below:
I don't want aff and src separated. I want them to be grouped. Wanted result:
Please help me! |
| Comments |
| Comment by Noopur Gupta [ 09/Oct/23 ] |
|
Hi Ahmad, I see you have posted this question on the Developer Forum. I request you to follow up on the forum if you still need help with aggregation pipeline to achieve your desired results. However, if there is a bug with the aggregation, feel free to re-open this ticket pointing us to the bug.
Thanks. |