Use saved values in JQL
This page describes how to search for values using JQL
Last updated
Was this helpful?
This page describes how to search for values using JQL
Last updated
Was this helpful?
Multilevel Select for Jira 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.
To find issues which include a multilevel select custom field, enter: "[customfield_name]" or "[customfield_name].levelX", where X is the number of level.
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
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.
Go to Issues > Custom fields.
Find a multilevel select custom field which you want to configure.
Click Edit details.
4. Check Search template.
Let's check how to save searching as a filter and use it on the dashboard.