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.