I have 2 entities with many to many relationship based on CDS :
- Entity 1: "Drinks"
- Entity 2 : Flavours
A drink have multiple flavors (ex : Apple, Lemon, Orange) also, a flavour can be in multiple drinks.
when I navigate to my screen, I passed a context variable "Apple" and on my screen I have a gallery of drinks, I would like to filter this gallery to show only drinks that contains "Apple" flavour (without delegation issue because I have more than 2K records).
Is there a way to do that within filtering ? Or it is better to create a collection filtered on the app start ?