Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Custom Interactive Filter with OR Condition

GADE RAMANJANEY
Kilo Contributor

Hi All

I have requirement on Custom Interactive Filters,

in my custom table

two fields are there

caller_location, Assigned_to_location


i created custom reference interactive filter with interactive filter references for that two columns

i added this interactive filter to my dashboard

this filter is working like caller_location AND Assigned_to_location

but my requirement is like caller_location OR Assigned_to_location

for example caller_location= india OR Assigned_to_location=india

i need to get the records any field have location india


for this reference is

https://www.youtube.com/watch?v=rgxuR1nlOJU

i followed this then also i didn't get solution

one more reference to understand my question 

https://community.servicenow.com/community?id=community_question&sys_id=dc2412ccdbb05fc0032a7a9e0f9619d3

Guys Please help me

Thanks in Advance 

 

3 REPLIES 3

Adam Stout
ServiceNow Employee
ServiceNow Employee

You'll need to write a custom interactive filter and add in the OR logic.  OOTB filters do not support OR.

 

could you please send me any reference code for OR logic, actual requirement is i just wanted to use OR condition  from single table on  multiple fields.

You can start here:

https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/dashboards/co...

Essentially, you just need a user input and some JavaScript to build the encoded query string you want to see.