LogoLogo
👉 Get a free ITSM ebook
Custom Fields Suite
Custom Fields Suite
  • About Custom Fields Suite for Jira
    • Main features of cascading field
    • Key benefits of cascading custom field
  • Using app
    • Multilevel Select
      • Use on the create issue view
      • Use on the service desk portal
      • Use saved values in JQL
      • Translate options
      • Gadget on dashboards and filters
      • Import or export options
      • Delete options
      • Use Cases
        • Internal service catalog
        • New hardware request
        • Incident Submission: App name and versions
    • Regex custom field
      • Use Regex on create issue view
      • Use Regex on the service desk portal
      • Use case
        • Phone number validation with Regex
        • Card Number Validation for Delegations
    • Dynamic custom field
      • Use case
        • Calculate total story points
        • Display the number of linked issues
    • ⭐️ Best practices
    • 💬 FAQ
    • 🔐Security statement
    • 🚧Known limitations
    • 📚 Featured articles
  • Integrations
    • Jira REST API integration
    • JSM Automation integration
    • EazyBI reports
    • Migrating from Multi-Level Cascading Select
  • 🤝Support
    • Book a free demo 📆
    • Request a bug 🐞
    • Share your ideas 💡
    • Appsvio website 💻
  • For solution partners
    • Partner Portal
    • Our Partners 🫶
  • OTHER APPS BY APPSVIO 💖
    • Feature Bundle for JSM
    • Issue Templates Agent for Jira
    • Issue Merger for Jira
    • HubSpot CRM Integration for Jira
    • Customer and Organization for JSM
    • Issue Scheduler
    • ITSM Reports
Powered by GitBook

Security

  • Privacy Policy
  • Appsvio Trust Center

appsvio.com © 2025 All rights reserved

On this page
  • Example
  • Forge custom field searcher

Was this helpful?

Export as PDF
  1. Using app
  2. Multilevel Select

Use saved values in JQL

This page describes how to search for values using JQL

PreviousUse on the service desk portalNextTranslate options

Last updated 10 months ago

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.

For more information about JQL searching, see the official Atlassian documentation on and .

To find issues which include a multilevel select custom field, enter: "[customfield_name]" or "[customfield_name].levelX", where X is the number of level.

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

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

  1. Go to Issues > Custom fields.

  2. Find a multilevel select custom field which you want to configure.

  3. Click Edit details.

4. Check Search template.

👉 Next steps

Let's check how to save searching as a filter and use it on the dashboard.

Advanced Searching
Advanced Searching Functions
Gadget on dashboards and filters