Multi index aggregations

Hi all, I've a scenario like this

Im maintaining an index for a list that holds the basic fields like title
I also maintain two separate indexes called idx-1 and idx-2 which also have listId as a field.
When Im adding an entry, I decide the index based on user input and store data there.

Now, when i retrieve multiple lists from the list index, i want to count all the documents from idx-1 and idx-2 for each list (more like a count subquery in SQL)

Can I do this with Elastic? this aggregation involves connecting multiple indexes to get the result

I don't know if this is exactly your problem but it's the same context.

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