This blog was originally posted by Matt Doar on March 31, 2014. It was last updated by Gretchen Pawloski on October 13, 2020.
Almost 15 years ago, JIRA custom fields feature was introduced. Different types of custom fields evolved, gradually improving how they displayed their data and how they could be used in searches. Over time, more JQL functions gradually appeared with each new release.
One custom field type in particular gained momentum quickly because it made navigating long drop down lists dramatically easier. A Cascading Select List is a JIRA field with two levels of select lists. What you see in the second select list depends on what you chose in the first select list, as shown below. This is clearly much simpler, easier and faster than having hundreds of options appear in one - very long - select list.
How Can You Use Cascading Select Lists?
When the Cascading Fields feature was first introduced, there were several issues. You couldn't use cascading select list fields in the JIRA statistics gadgets on dashboards and you couldn't search for issues with certain values in cascading select list fields. As you can imagine, these limitations were frustrating to users. Fortunately, these capabilities now exist. Below are just a few examples of ways to use Cascading Select Lists.
Add Cascading Select Lists to Gadgets
Cascading Select Lists can be added to gadgets such as the pie chart gadget shown below. The parent and child option names are nicely separated with a dash, and as you might expect, clicking on any of the pieces of pie shows those issues in the Issue Navigator.
Search on Cascading Select Lists
There are some interesting edge cases around searching on cascading select lists. What happens if you have two different parent options that have child options with the same name? In our example field, this could be if both Europe and Asia have a child option named "Turkey". As the above below shows, JIRA does the right thing.
Build Workflows and Mappings with Cascading Select Lists
Using Connector for Salesforce & Jira, your teams can easily create robust workflows that use Jira Cascading Select Lists and Salesforce Dependent fields to create easily managed select lists that provide a seamless experience for both admins and end-users. Admins can set up a range of options for synchronization modes when selecting a cascading field to map.
Query on Cascading Fields
We've compiled a short list of different cases that you might want to search and the corresponding matching JQL queries. The custom field in this case is named "Region and Country".
- For all issues with the parent option "value1". When you start typing the value, JIRA shows the first 15 values for the custom select list field by default.
JQL: "Region and Country" = value1
- For all issues with the child option "value2". This will show all issues with child option value2 no matter what the parent values are.
JQL: "Region and Country" = value2
- All issues with no value at all in the custom field:
JQL: "Region and Country" is empty
- All issues with the specific parent option "value1" and child option "value2"
JQL: "Region and Country" = value1 and "Region and Country" = value2
JQL: "Region and Country" in cascadeOption(value1, value2)
To search for issues with more complex combinations, you'll need to use the cascade Option JQL function.
- For all issue with the specific parent option = value1 and no child option set
JQL: "Region and Country" in cascadeOption(value1, none)
Now that you've seen just a few of the many different ways to search on cascading select list custom fields and display the results, we hope you'll find it helpful in your own use case.
As an authorized training partner, ServiceRocket has provided official Atlassian courses to over 50,000 Atlassian product admins, users and power users. We're ready to help your team drive software adoption and the effective use of technology.
We've got your back.
Build expert proficiency faster with ServiceRocket's Atlassian Training