Subprojects JQL Function

Subprojects JQL Function

You can use subprojectsOf JQL to query projects contained inside any level of subprojects hierarchy. For example:

project in subprojectsOf("1-Service Management") project in subprojectsOf("99-Archive") project in subprojectsOf("2-Core Enterprise Projects")
Screenshot 2026-02-06 at 10.01.19.png

 

Operators and brackets

The function supports the in operator only; not in is not available. To exclude a hierarchy, negate the whole condition:

NOT (project in subprojectsOf("99-Archive"))

The function has to stand directly after in, never inside brackets. Inside brackets Jira never evaluates it and raises no error — the condition simply stops filtering. Several hierarchies are therefore combined with OR rather than listed in brackets:

project in subprojectsOf("1-Service Management") OR project in subprojectsOf("2-Core Enterprise Projects")

The same rules apply to every function of the app — see JQL Functions.