Struggling with creating Interactive Filter Reference

[pheenan]

I created a report from the Requested Items Table. I am trying to create an interactive filter that allows me to search/query the report. There are thousands of records in the report and the user wants to be able to search an RITM in a search box that will dynamically change the report to bring back the RITM he searched for. 

I believe I created the Interactive Filter correct (see screenshot)

However, the next step is to create a Interactive Filter Reference (see sceenshot)

I click new 

The last thing I thought I had to do was get the reference table (sc_req_item) and then select the reference field i want. Because i want to search for RITMs within the record I searched for that but it is not an option. 

Does anyone know how I can resolve this issue or an alternative way to search RITMs within the record I created?

Please let me know of any questions.

Thank you.

[Adam Stout · Accepted solution]

You can't (be default) apply an interactive filter on the table that the filter is based on.  It cannot select itself.  The filter is used to filter other tables.  For example, a filter on user can be mapped to requested item based on the assigned to user.

What reports are you trying to filter?

If you do need a self-referencing filter, I put a note on how to do it on this thread:  https://community.servicenow.com/community?id=community_question&sys_id=eb0d2bdc1b979c908672ea89bd4b...

[pheenan]

Adam, our team ended up doing a custom interactive filter to search within the report. We actually used your code from Custom Interactive Filters - Aug. 8, 2019 Performance Analytics & Reporting Office Hours - YouTube (around 14:15). We got it to work for one search instance, but not another. Could you help with getting it to work? We believe it worked on the first instance because we were searching a field on the report that was a STRING. Is there a way to search the report when the field's input is a variable?