Skip to end of banner
Go to start of banner

Subqueries to Extended Search functions mapping

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Extended Search is a new way to perform complex searches in Jira. It improves your search experience over Subqueries in the following ways:

  • You can see the results immediately without any additional indexing steps.

  • You can save the query as a Jira filter and use the filter everywhere in Jira.

  • As with standard Jira filters, you can control the filter permissions.

  • Saved filters perform better than Subqueries and are more reliable.

How do I start using new Extended Search functions?

There is an equivalent function for every Subquery JQL alias. The full list of available functions is listed on the Extended search page. Have a look at the next section to see the mapping between Subqueries JQL aliases and new functions. It’ll help you to create your new queries.

For example, if you previously created a subquery component=UI and you use it to find epics of issues that are a part of component UI:

epicOfQuery="component=UI"

you can find the same Jira issues with epicsOfChildrenInQuery function:

issue in epicsOfChildrenInQuery("component=UI")

The big difference is that you can use the nested query “component=UI” directly in your main query and without the need to create and index a subquery first. You can even narrow down you query further:

issue in epicsOfChildrenInQuery("component=UI") and project in (ACME, SP)

If you want to use the query anywhere else in Jira simply save it as a filter.

Functions mapping

The following table list Subquery JQL aliases and their corresponding Extended Search functions. Use this mapping to migrate your subqueries.

Subquery JQL call

Extended Search function call

epicOfQuery=”subquery”

issue in epicsOfChildrenInQuery("subquery")

issuesFromEpicsInQuery=”subquery”

issue in childrenOfEpicsInQuery("subquery")

linkedByQuery=”subquery”

issue in linkedIssuesOfQuery("subquery") - matches both sides of the link

issue in linkedIssuesOfQuery("subquery", "link name") - only matches the links with a specific link name

linksQuery=”subquery”

same as linkedByQuery above

parentOfQuery=”subquery”

issue in parentsOfSubtasksInQuery("subquery")

subTaskOfQuery=”subquery”

issue in subtasksOfParentsInQuery("subquery")

issuesInQuery=”subquery”

Simply save your Extended Search query as a Jira filter and use the filter query:

filter="My Extended Search filter"

  • No labels