JQL query for all issuetype = sub-tasks that have a linked parent of an issue type

[steven_allcock]

Hi,

I want to get a list of all sub tasks where they have a parent

I.e 

Issuetype = Sub-tasks and linkedParent = [system] Post Incident review

ive tried something link this but get nothing back

project = TSD and issueType = Sub-task AND issue in linkedIssues("[System] Post-incident review")

(Error: Issue '[System] Post-incident review' could not be found in function 'linkedIssues'.)

any ideas of how or even if this can be achieved without buying an addon 

[Jack Brickey · Accepted solution]

Hi @steven_allcock , is the parent Issuetype "post incident review"? That is, are you trying to find all sub-task where the parent is "post incident review"? If so you cannot achieve this with native JQL. You would need an addon unless you wanted to do something like add a label to any sub-task of a PIR issue.

[steven_allcock]

Hi Jack,

yes thats right and what im trying to do.

That's a good suggestion with the label i can do that!

[Jack Brickey]

Cool. You can set up automation for subtasks created in the future and for the preexisting subtasks you can use JQL to find the parents and comb thru them to add label. Of course you could trial an add on app and use the advanced JQL feature to find and add labels with bulk edit. 

[Hannes Obweger - JXL for Jira]

Hi @steven_allcock

I'm glad you were able to resolve your issue! Just for future reference, if this is a problem you face more regularly: If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the parent issue type.

This is how it looks in action:

As you can see above, you can easily sort and filter by the parent issue type, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes