How to make for the Conditions in the interactive filter ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-07-2018 07:59 AM
It is a first time to work in a ServiceNow !. I search How to do for the Conditions in the interactive filter like for example (Business service = A or internal service = A) and active = true.
As firstly, I tested a report with a simple interactive filter, Where it contains a table "business service" with a business service variable from an Incident table. It starts well.
And now, I want to extract all records in function of one of 2 aeras : business service OR internal service of a same table "incident" with a same data ==>for instance : (Business service = A ) or (internal service = A ) and active = true,
Do you know how to do with theses conditions in using an interactive filter ?
I hope you understand my english ...
sincerely
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-07-2018 10:25 AM
Interactive filters are ANDed together. For what you are looking for, you'll need a custom interactive filter. Here are the docs (with a simple example):

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2018 02:44 AM
hi adam stout,
Thanks you very much for your answer.
I am not an administor but a developper !. Therefore, I believe that it could not to take a customer interactive filter. It is why I look for an other method !...
In theoretically, I tried to make a breakdown source named "AL - BS - IS GIO sec" using a table "business service [ cmdb_ci_service] " with conditions : Class ="business service" or " internal service" .
This breakdown source placed on the bottom of dashboard with an interactive filter group containing 2 interactives filters (*).
(*) For 2 interactive filters, it contains a Business Service variable of incident, for example and other, an Internal service variable of this table.
And then, I add a simple report "open" incident" in the tag "incident" . See the screenshot below. But the result is not good . Because, normally, the chosen data ,(from breakdown source), must display in one of 2 columns "business service" or " internal service"
this result is not good
=> I wish to see the correct result for example, see below . if I select a data "gio -sec - secure Remote Acces", this displays in one of 2 columns : business service or internal service. see an example below
as we did with a simple report without interactive filter , see below
and now, . How to make with interactive filter using the condition : active = true, only ?
It is no easy to explain it to you . I hope you understand what i mean .
In advance, thank you for your next answer
sincerely
B.Delcroix
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2019 10:56 AM
I am also looking for a solution on this. Particularly because I need this to work together with a PA breakdown at the top of a dashboard. There are times where I am doing a database view joining different tables and a field such as Assigned to or assignment group are different fields in that view.