Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

steven_allcock March 19, 2024

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 

2 answers

1 accepted

4 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2024

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 March 19, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2024

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. 

Like steven_allcock likes this
0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 21, 2024

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:

parent-issue-type.gif

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events