Passing the interactive filter value to the report conditions in the dashboard

Tomasz Czechlew
Tera Expert

Hello 😄

I have this problem.
I am creating a dashboard with inflow and outflow incidents reports. The dashboard is supposed to have an option to select the group for which the reports are displayed. So I created an interactive filter that allows to select the group as required.
The problem is that I need to use the group selected in the interactive filter for the report conditions. The idea is that the report should include incidents where the group is in the Assignment Group History field. So I need to querry this field in the incident table.
I have created a script include to search the incident table, however, I don't know how to pass the selected group from the interactive filter to it.
I tried to do it this way. I typed in the condition:
[Assignment Group History Report] [is] [ javascript; new ScriptIclude().Function(getElementById("select2-chosen-3"));]
Unfortunately it doesn't work.
I tried to find something in the API but I didn't find anything either.
Is it technically possible to do something like this? How to catch this value?

Thank you in advance for your help and answers.

 

1 REPLY 1

Tomasz Czechlew
Tera Expert

Hello.
I managed to find a solution to my problem, so I will write if someone has a similar one in the future.
I managed to achieve the effect using customized interactive filter. Useful information on how to build such a filter, you will find in the link below.
https://developer.servicenow.com/connect.do#!/event/creatorcon18/CCW1161

Hope it will help somebody