Use saved values in JQL
Multilevel Select provides a dedicated JQL searcher that lets you search for issues which include a filled multilevel select custom field. It works slightly different in comparison with regular select or cascading select custom fields. Each level has its representation in JQL.
This searcher can be used in any place in Jira where using JQL is available: in the Issue Navigator, in a Saved Filter, as an Agile Board query, etc.
Info
For more information about JQL searching, see the official Atlassian documentation on Advanced Searching and Advanced Searching Functions.
To find issues which include a multilevel select custom field, enter: “[customfield_name]” or “[customfield_name].levelX”, where X is the number of level.
Info
In the advanced view in the Issue Navigator JQL autocomplete works only for values which have already been saved on issues. If an option is added in the configuration but is not yet selected on any issue in Jira, the autocomplete will not suggest it.
If the option still fails to suggest despite appearing on the issue, check if JQL autocomplete is set to ON in the configuration. As a Jira administrator, go to the System > General configuration > JQL Auto-complete.
Example
Let’s look at the multilevel select custom field called “Provide your country”. Its structure is shown below.
Provide your country
| Level 1 | Level 2 | Level 3 |
|---|---|---|
| USA | ||
| California | ||
| Fresno | ||
| San Jose | ||
| Florida | ||
| Nevada | ||
| Europe | ||
| Germany | ||
| France | ||
| Italy | ||
| Africa | ||
| Australia |
Below are examples of how to search for issues depending on the values entered in the multilevel select custom field.
| JQL | Description |
|---|---|
| “Provide your country.level1” = USA | Search for issues where USA is selected on the first level |
| “Provide your country.level2” = Florida | Search for issues where Florida is selected on the second level |
| “Provide your country.level1” = Europe and “Provide your country.level2” = Italy | Search for issues where Europe is selected on the first level and Italy on the second level |
| “Provide your country.level3” = Fresno | Search for issues where Fresno is selected on the third level |
| “Provide your country.level3” != Fresno | Search for issues where on the third level is different value than Fresno (additionally, the third level must have any value) |
| “Provide your country” ~San | Search for issues which contains a word ‘San’ on any level |
| Provide your country is EMPTY | Search for issues where custom field is empty |
| Provide your country is not EMPTY | Search for issues which contains at least one value in the custom field |
Info
You can create up to 7 levels for each multilevel select custom field. This limitation is due to performance issues.
Forge custom field searcher
In case of any issues with JQL, check if the proper searcher is set for the multilevel select custom field. The valid option is Forge custom field searcher.
Steps
- Go to Issues > Custom fields.
- Find a multilevel select custom field which you want to configure.
- Click Edit details.
- Check Search template.
