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")
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.