Multi Select Field Needs to APply filter on another Filed

[Rayman Bacchus]

Hi All - hoping you can assist

I have a multi-select field where users can choose options  01 - 06 called ProductGroup

I want to use ProductGroup to apply a filter on a field called BusinessCapability

I currently have 2 rules sent up

if ProductGroup:01 then apply filter to BusinessCapability showing option 1,3,4,6,7,9

if ProductGroup:02 then apply filter to Business Capability showing option 1,3,5,8,12

The issue is if I multiselect ProductGroups 01 and 02 together only the BusinessCapability options 3,5,9,12 are showing.

So I want to select ProductGroups 01 and 02

and the filter on BusinessCapability to show options 1,3,4,5,6,7,8,9,12

How would I go about doing this?  Is it even possible?

[Asha Goyal]

Hello @Rayman Bacchus 

Are you using Scriptrunner? As this is something that can be done with the help of scripting.

Regards

Asha

[Rayman Bacchus]

No I don't use scripts.  I'm not en expert coder so I would have no idea how to implement or run such a script. 

But am willing to take guidance if someone shows me how and it is the optimal solution.

I should also mention my companies version is Confluence is very limited and am stuck with what may be best considered Out of Box solutioning so ScriptRunner is not an option