How can I filter on parent item type?

[Wayne Erfling]

How can I filter on parent item type?

In our system we have DEV sub-tasks under Support Tickets and DEV sub-tasks under stories.

So I want to write the following:

   WHERE ParentType IN ("Support Ticket")

but I don't think I can.

Or can I?

[Jack Nolddor _Sweet Bananas_]

Hi Wayne, sadly this cannoy be achieved using native functionality. You need to go for a third-party instead. Using i.e. JQL Booster Pack you can type the following:

Search for subtasks created under Stories or Support Tickets:

issue IN subtasksOf("type IN (Story, 'Support Tickets')")

Search for Support Tickets with Subtasks

type = "Support Tickets" AND issue IN hasSubtasks()

Serch for closed subtasks created under 'In Progress' Stories:

status = Closed AND issue IN subtasksOf("type = Story AND status = 'In Progress'")

Serch for Stories or Support Tickets with unresolved subtasks:

type IN (Story, "Support Ticket") AND issue IN parentsOf("resolution IS EMPTY")

References:

• Official Documentation

Don't hesitate to ask for help if you need to create complex queries,

Regards

[Muhammad Ramzan(Atlassian Certified Master)]

You can achieve this using third party plugins like scriptrunner or  JQL Search Extensions for Jira & reports.

I am using  JQL Search Extensions for Jira & reports. and following query can help you 

issue in subtaskOf("issueType = 'Support Ticket'")

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-ParentOf(jql-query)

[Mohamed Benziane]

Hello @Wayne Erfling 

It's not possible out of the box. But with an addon like scriptrunner you can achieve that. There is a jql function parentOf.

I think this feature can fit your requirement. Or you can also use subtaskOf (from scriptrunner too)

Hope this helps.

[Polina Semykina]

Thx