Dashboard with a text/dropdown search for parameters like node name, resource name.
I have created a report for total alerts of a particular source and added it to a dashboard.
Then total alerts populated on dashboard.
I need to filter alerts based on node name, resource name by dropdown/search.
I tried Interactive filter , then cascading filter by using 'Table' as "alert(em_alert)" and 'Diplay field' as 'Resource' to retrieve alerts. Aslo added souce name in filter(all records matched with this filter available on dev instance). and updated target table as "alert(em_alert)".
Now I added this filter on dashboard, now I want to get alerts count by resource name. I selected one resource name(ex:Abc-g) and cliclked apply. I got 0 alert count. But there were many. and clicked on 0 alert count. Then observed that All> Resource = xyz.....(sys_id of alert) > Source = IND-KAR instead of All> Resource = Abc-g(resource_name) > Source = IND-KAR. I observed that the "resource" field's type: "string". Please help how do I retrieve the resource name for this type.
