We had almost the exact same issue, but with Major Incident rather than Incident. Thanks to a suggestion from Adam Stout, we managed to get it to work.
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!
Rahamathullah,
Based upon the business requirements you stated earlier "assignees are having 40 + incidents in the report , now using interactive search they have to get the incident numbers as for their need.", I don't think an interactive filter is the best path to meet the business requirement. I am making an assumption here but it sounds like you want to provide the user a report displaying a list of all incidents currently assigned to them.......does that sound accurate? If so, you can build regular list report and use a dynamic condition. In my example, I am using the incident table to build a list report with provides a list of all active, open (not closed or cancelled) assigned to the logged-in user. When you add the filter condition for "Assigned to", it will provide you with a list of options......one of them being is(dynamic). Select is(dynamic) and Me as the condition qualifier. This will provide a pre-filtered list of incidents assigned the individual viewing the report. Since I was logged in as Fred Luddy, you will notice the final report only includes those incidents currently assigned to him.....and the results of the report will dynamically change based upon who is logged in.
Does this satisfy your business requirements?
Ashby
