Custom Interactive Filter with OR Condition

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2019 07:35 AM
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
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2019 10:59 AM
You'll need to write a custom interactive filter and add in the OR logic. OOTB filters do not support OR.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2019 11:08 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2019 07:54 AM
You can start here:
Essentially, you just need a user input and some JavaScript to build the encoded query string you want to see.