Hello all. For an app I am building, I require the use of many to many relationships. I am using CDS. I have an entity called "agency" an entity called "tags" and an entity called "tagsmap" that maps tags to agencies and vice versa:
Agency {PrimaryID, name}
tagsmap{PrimaryID, Agency_ (a look up to agency), tag_ (a look up to tags)}
tags{PrimaryID, name}
I want to be able to search for tags and get the names of all agencies that have the tag associated. My process right now looks like this:
1) fitler tags based on a text string and collect the filtered tags
ClearCollect(TempTags, Search(tags, searchbar.text, "name"))
2) filter tagsmap based on the collection of filtered tags
ClearCollect(TMapResults, Filter('tag map', tag_ in TempTags))
This retuns a list of tagsmap entities which have tag entities and agency entities nested within them:
{tagsmap: PrimaryID, Agency_, tag_}I am stuck here. How do I filter TMapResults in a way that returns agency names?
Thanks!
