disjunction query for JQL filter

Question

On our project we want to track of cycle time for stories, tasks and sub-tasks. In using the control-chart we need to avoid double-counting where a story or task has sub-tasks (simple stories or tasks don't have sub-tasks in our world).

So I'd like to have a filter that would be a disjunction of sorts - include all sub-tasks, and only stories and tasks that have no sub-tasks.

looking through the JQL documentation I can't see a way to do this

Alexey Matveev · Answer

Ah, you are right. You would need to look for a plugin, which supports JQL functions for Cloud.

james_warr · Answer

Thanks for the suggestion, but unfortunately Power Scripts for Jira Cloud doesn't support SIL JQL functions

Alexey Matveev · Answer

Hello,

You can not do it with the out of the box JQL, but you could use an add-on.

For example, you could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL query would look like this:

project = test and issuetype in subtaskIssueTypes() or not (key in hasSubtasks("project = test"))