JQL filter: show tasks where subTasks was not created sins 3 weeks

[mad_irfan]

hi

is there a way to search for ALL Tasks "issuetype task"  were SubTasks was not created sins 3 weeks.

thx for your support ;)

[Jack Nolddor [Sweet Bananas] · Accepted solution]

Hi mad irfan,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Search for Tasks were SubTasks was not created sins 3 weeks, i.e.:

issue IN hasSubtaks() AND issue NOT IN parentsOf("type IN subTaskIssueTypes() AND createdDate > -3w")

Note that this is just an example, you must tune above query to fit your needs

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards