It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I create a relationship between multiple select lists?

I am on the hunt for a plugin that will let me establish a relationship between three fields in a way that will let me set up select lists for each field, and when a selection in field 1 is made I see a subset of field 2's options, and when a selection is made in field 2 I see a subset of field 3's options.

So Imagine:

Field 1 - General category (hardware, software)

Field 2 - Sub-category (Hardware options might be Monitor, keyboard, stress ball, etc.  Software options could be Word, Jira, Photoshop, etc)

Field 3 - Symptom (For keyboards maybe keys stuck, not responding, etc.  For Jira it could be workflow transition missing, etc)

The essence of this is the selection in Field 1 determines what options are available for field 2, and field 2's selection determines what options are available for Field 3.

If dynamic forms does this I will be happy.

If not, how can this be done in a way that is not a nightmare to maintain and is upgrade safe?  Oh, and can be implemented by someone that doesn't know how to work with ScriptRunner.  Just in case that's the only option.

3 answers

1 accepted

0 votes
Answer accepted

Hi @Robert Horan 

Have a look at Multi-Level Cascading Select.

Jira natively can't have 3 level (only 2 are supported).

I hope it helps.

Ravi

YES!  Perfect, thank you!

As far I know Script runner is the only option. It comes with behaviours component. You don't really need to know any scripting to do this

For a little bit of an outside the box solution. You can probably use CPrime's Database custom field, as it has the ability to parent/child relations in fields such that the parent can be used in the query of the child and updates dynamically.

You would have to keep your list of options in a separate database. (can use the same postgres server, but its own database with its own tables.) (This could be a pro or a con depending on your point of view.)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

314 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you