Reference Interactive filter - How to make it filter records from the same table?

[Yanal]

Hello everyone!

I have a reference interactive filter that is on the Product table. I want the filter also to give results for reports on the same table because it does not allow me because there is no filed of type Product in the table....

This only filters other referencing tables.... 

any idea how I can make this work?

[Community Alums]

If product field isn't present on reporting table, then on what basis the dependent report will get refreshed/narrowed down?

You have to let system know that there is a relationship between the table/field used in interactive filter, and table used in dependent report. Open the interactive filter > goto related list "Interactive Filter References" and make a relationship there.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/dashboards/task/t_CreateAReferenceFieldPublisher.html

Thanks
Anandsagar

[Yanal]

We created self reference field. 

Thanks you for your reply 😄 

[Adam Stout · Accepted solution]

You can modify the BR that blocks you from adding it but this may lead to some upgrade issues at some point.

Alternatively, you can dd a new field to the table that references itself.  Set this via an insert BR to the value of the sys_id.  You can then add an interactive filter on that field.

[Yanal]

That is what we did 😄 
i am marking it as correct for other people, 

Self reference field on the same table.