(isDynamic) Option for Interactive Filters

[daburges]

Hello All,

I am attempting to create Interactive Filters to allow my colleagues to use data visualization in order to increase their efficiency at work.

I am currently attempting to create in interactive filter that can alter the assignment group and the assigned to fields of the INC table, which is the parent to the TASK table which contains INC, RITM, and CHNG.

Below, I have a screenshot of an interactive filter I created to filter the assignment group of any reports that interacted with either the TASK or the INC table

This Interactive Filter layout works for both INC and TASK, However, I am only able to select individual groups.

Below is a screenshot to highlight my intended functionality within a Report context:

I would like to be able to copy this filter functionality within an interactive filter.

My main question: can this be achieved with an Interactive Filter or must I implement this change in a Report?

Thank you for your time and patience.  

[mike_bush]

I think you mean that INC "extends from" TASK so in many ways task is the parent but we don't use that term.

Anyway, it appears that the Interactive Filter builder has not caught up with the new "Is Dynamic" way of working. This means you have to build a good-old Javascript condition, I have used "is one of" and "javascript:getMyGroups()" at TASK level.

And don't   forget to set the "UI control type" to "Select Multiple Input"

Then you should have a filter which can be used on any task-extended object.

[daburges]

That sounds like a very implementable solution. While I have seen instances of this in reports I was wondering if you could elaborate on where I could add this javascript condition as a choice in the multiple input UI Interactive filter for a reference filter? For example, I understand multiple inputs for a field that is classified as a choice list I can filter the list of potential choices a user will be shown.

However, since the list for reference filters are pulling from a separate table I don't understand how to add options such as the very excellent idea you posed.

Thank you for your time.

[mike_bush]

I built this :-