Jira Snippet Library: JQL - Subqueries

[#1]

Sub or Nested Queries

A subquery is a nested query or a query that contains a query.

For example, create and save the following filter:

• Filter name: Support Spaces

• JQL: project in (HELP, SUPPORT)

Then, append additional clauses to the filter’s name or ID.

• filter = “Support Spaces" and assignee = currentUser()

• filter = 10306 and assignee = currentUser()

The above queries are equivalent to:

• project in (HELP, SUPPORT) and assignee = currentUser()

Tip: Find a filter’s unique ID from the “View all filters” page. Hover over a filter’s name to see the ID in the browser’s status bar or click the filter’s name to see the ID in the address bar.

Ex URL: https://sitename.atlassian.net/issues/?filter=10306

---

Back to intro or article list

[Charlie Misonne]

I really like using those reference to other filters. It's great when you have a lot of similar filters and you don't want to update all of them when there is a change.

In my experience it is rarely used and underestimated.

The downside is the lack of transparency: you cannot really see what you are filtering for.