Filter options from an interactive filter

Fabs
Kilo Explorer

5 hours ago

Hello All!

 

I am trying to create an interactive filter for a report which would allow a user to to select a task type (eg. INC, RITM, TASK) and filter other reports or lists.

 

I created a filter based on a choice list with the following configurations

Fabs_0-1767397471195.png

 

Doing so created a drop down like below

Fabs_1-1767397518920.png

 

but I would like to only show the "Security" task types, is this possible? So basically filter the options in the choices of an interactive filter. I have tried with exclusions and inclusions but did not work as expected as well as changing the "Filter based on" to a Reference type.

 

The end goal is to just be able to select a task type from the filter and filter other reports, but there are too many task types and I would like to reduce them to only the ones we care about. I was able to do this for an Assignment Group interactive filter using Reference, but cannot replicate this for the Task table because it returns the actual task numbers and not the types.

 

Thank you!

 

 

0 Helpfuls
  • 102 Views
1 REPLY 1

Ankith Sharma
Giga Guru

13m ago

Hey @Fabs , what you are trying that can't be done because, you can’t filter or restrict the choices of a Choice-based Interactive Filter. This is a platform limitation. That is because of Interactive Filters that use Choice always show all dictionary choices. Inclusions/exclusions, conditions, or reference qualifiers are not supported for choice lists.

 

That’s why you can’t limit Task types to only Security ones. Switching to Reference doesn’t work. Assignment Group worked (it’s a reference field), but Task type doesn’t.

 

What you do is use a Scripted Interactive Filter and filter on task.sys_class_name, returning only the Security task tables you care about (e.g. Security Incident, Security Case, etc.). This is the only supported way to reduce task types in an Interactive Filter. Or you can also create a custom “Task Category” field (e.g. Security / Non-Security) and build the Interactive Filter on that field.

 

 

If this was useful and didn’t make things worse, please mark it as Accept as Solution and Helpful 😄

Regards,
- Ankit
LinkedIn: https://www.linkedin.com/in/sharmaankith/

 
0 Helpfuls