How to make for the Conditions in the interactive filter ?

Naples1966
Giga Contributor

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

3 REPLIES 3

Adam Stout
ServiceNow Employee
ServiceNow Employee

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):

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

Naples1966
Giga Contributor

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
find_real_file.png

 

=> 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

 

find_real_file.png

as we did with a simple report without interactive filter , see below

find_real_file.png

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

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.