Interactive Filter References

John Knopick · ‎03-28-2023

Hi Everyone!

I am pretty sure there is a way to do this, I just cannot figure out how. I want to create an Interactive Filter that will allow me to pull data by an Agent's name. I need the filter to look at Assigned to OR Closed by OR Opened by. Right now the way I have it, it's looking at all of those as AND's instead of OR's. What would be the best way to accomplish this? I'm not finding a way to tell it to use those Reference Fields I selected in the way I would like.

Any help would be INSANELY appreciated. Thanks so much!

John

AnveshKumar M · ‎03-28-2023

Hi @John Knopick ,

You can try using the custom interactive filter using content block.

Refer this answer for a quick start,

https://www.servicenow.com/community/developer-forum/need-help-on-interactive-filter-report-conditio...

Thanks,

Anvesh

Thanks,
Anvesh

Tsura Andreeva · ‎04-21-2023

Have you tried mapping the interactive filter to the table and its respective fields as reference?

John Knopick · ‎04-21-2023

Hi Tsura!

Problem is by doing that, it will search for all 4 of those as "AND" instead of "OR". I've tried this, and it only looks for tickets that are Opened by AND Resolved by AND Assigned to AND Closed by, which doesn't give me the data I'm looking for. I need to find a way to tell it to make those 4 reference table fields to be OR's. So if you've got any ideas on that, that would be amazing!

Tsura Andreeva · ‎04-21-2023

Ah I see now, sorry - I think you will have to create custom interactive filter or a content block to search.

This person created one for approvers, I bet if you play with it you can change it:

https://www.servicenow.com/community/developer-forum/help-on-content-block-for-search-box/td-p/25314...