Aggregate whole groups when search machtes only a few items of that group

Hi, i am looking for a solution of the following problem.

I have 20 million "Item" objects. Each Item Object have a GroupId property where 1-5000 Items a grouped together. Each Item has some other properties we can use to filter.

My problem is now that I want to get and aggregate all Items of a group where my complex search (on the other properties) matches at least one item of that group.

If I would only get the items, I could do a search where I get all GroupIds from my complex search. And then do a simple query to get all data where GroupIds in that list.

But how to aggregate that? Especially when there can be 1mio Items in the resultset?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.