Use of presentation value for key value in (access) filter
Using the latest 8.0.5 release.
We work with hospitals which have a CIC code. This is an unique code for each hospital that is used in most of the tables in our DB. There is ofcourse also a dim hospital table in which the detaildata for all hospitals is saved (full name, main contact, telefoon, city, e.d.)
We use LDAP for authentication/autorisation and each hospital has a group (based on the CIC code) in the endusers are saved.
In our view I have set the CIC code to link to an access filter on the datasource. This is all working fine but ofcourse in our filter we now have the CIC code and we would like to show the name of the hospital.
How to realize that?
It looks like there can only be one input field in a filter. And I would like the key field (CIC code in my case) and a presentation field that is shown in the filter. This can be the name or even name and CIC code combination like "hospitalname (CIC-code)".
I currently have my filter set up to show access filter values:
But then it is only showing the CIC codes.
I can set it to custom query in which in which I can then set my query but YellowFin is telling me to make sure the query return only a single column.
And even if it would allow me to use multiple columns how would I refer to the access filter so the CIC codes I see as a result are only those CIC codes I am authorized for.
I would expect this to be relatively simple but I am unable to get it done.
Please let me know if this scenario is possbile and if so, help is appreciated because it is not obvious to me how to do it.