Hi,
I need to create a interactive filter for Incident Number. As of now I couldn't add the related field for the incident Number filter.
I hope I need to create a custom Filter from the content block. Please Let me know how to map the interactive filter in dynamic content
Hi Vasuki,
1. Set up your Interactive Filter, with type Reference, pointed to the Incident Table with a filter on Number (because it won't let you pick sys_id).
Create your interactive filter reference. You can't reference incident itself, so instead point it at any table that references incident: (maybe parent_incident? or Problem)? and set the field to the incident reference.
Click the i to open the record you created, then right click to export to XML
In the XML, edit the reference_table and set to incident - edit the reference_field and set to sys_id
Save it, then go back to the instance and import the xml file back in (you may have to ask an admin to help, if you're not admin yourself).
Now when you look at the Filter Reference, it should reflect the incident table and sys_id field.
Add your Interactive Filter to the dashboard, and make sure your other report widgets are set to "Use Interactive Filter", and it should follow!
You can refer to these links :
Hi Vasuki,
I have a straightforward solution for this problem. If anyone is experiencing a similar issue, just follow these steps:
- Navigating to Report -> Administration -> Interactive Filter
- Create new interactive filter based on "Reference"
- In "Interactive Filter References" Related List, create new.
- As the Incident Number field is a string, it cannot be utilized in the reference interactive filter. However, we can leverage the parent incident field instead.
Output:
I hope this solves your issue
Mark this as Helpful / Accept the Solution if this clears your issue
Regards,
Durga
