How to make for the Conditions in the interactive filter ?

Naples1966 · ‎03-07-2018

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

Adam Stout · ‎03-07-2018

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 · ‎03-08-2018

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

dustinh21 · ‎04-15-2019

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.