Search repeating group with entity in an a different table

I have a scenario where I have a repeating group with Orders. The orders repeating group shows Products and customers that are pulled from related table. In my usecase I would like to have two filter components Customer and Product Category which are actually not part of the repeating group table.

I need help with query on how to filter by product category and customer.
Thanks for all the great support.

1 Like