Hi Team,
I have created a report from Database view i have created and added this to a Dashboard. I now need an Interactive filter to filter the results based on value field. Value field contains user names in it.
Database View - metric_instance is combined with our Case table and combined with sys_user table as shown below. Reason, when metric_instance is created, user's name who made the update is passed onto the value field.
Now when i view the Database view, i get all the information i need as shown below
I have added this Database view in a report and added that to a Dashboard. I now need an Interactive filter to filter through Value field from Database view shown above. Value field basically has User in that field.
I tried using a Reference type interactive filter and linking the Database view in interactive filter reference - but User does not appear there.
I tried Custom interactive filter. Could not make it work.
I followed the following forums articles with no luck
Please help.
Create a reference interactive filter on the sys_user table
once created map your new table view on the bottom as the reference and add the field like so, if you already have assigned to interactive filter, just add your table to the reference configuration on your current interactive filter
I tried using a reference type interactive filter on Sys_user table. Issue is when mapping the field. As the table i use is Database view, i cannot find any user type field on the Database view table. See below
