Perfect - That is a great solution and although it does feel like a bit of a blunt workaround (e.g. building a compound key in this way does allow for proper filtering and sorting ), it certainly gives me what I need to help the end users pick the right product that relates to a data asset.
It does seem to have created another issue though....
As you can see in the picture below, the compound text is showing on the Product Asset in the title [Address Validation - Version number] so all working there.
You will also see the Data Assets on the related asset tab is showing the compound text for Asset name - [sales status]. Again this is great. And when I click the [+] icon, this compound text is shown to help product owners only select "Live" assets.
However, I no longer be able to add extra fields to the grid view. (before you press the [+] button). I used to be able to select the listable field and sort order to create proper grid show 3 seperate fields of [NAME], [STATUS] &, [DESCRIPTION]
How can I have BOTH options, the compound key for the adding new relationships and also showing the 3 (or more) fields to the grid to pull through all the relevant information I need.
Any thoughts?
