Linked Issue Query

aarthie_ramachandran September 4, 2024

I have a support project that can have many linked issues in many projects. e.g. support project is TKT and can have linked issues in projects A, B, C, D. 

I am looking for a JQL to identify all the issues in project = TKT that have linked issues in Project A and the status of project is not done. I am having difficulty using the linked issues

query

3 answers

0 votes
Jason Chayer
Contributor
September 4, 2024

@aarthie_ramachandran  - could the jql below work? I have a similar situation where I use a project for expedited issues, but have linked tasks to development projects.

project = "TKT" AND issueLinkType IN ("whatever your linked issue type is named") AND status != Done

aarthie_ramachandran September 4, 2024

No, I am looking for issues that can be in Project A, B or C

Jason Chayer
Contributor
September 5, 2024

@aarthie_ramachandran - how do the linked items from A, B, or C appear in project TKT?

 

aarthie_ramachandran September 6, 2024

@Jason Chayer It will be something like this. Bold text is Jira fields, Italicized is my explanation, data is actual Jira data

Issue-Key

Issue-Ids in Project TKT

Inward issue link (Blocks)

TKT can have linked issues in Project A or Project B 

Inward issue link (Problem/Incident)

TKT can have linked issues in Project B or Project C

TKT-12488GT-6751 
TKT-12459FX-16199 
TKT-12398 FX-16170
TKT-12380 PS-11369
Jason Chayer
Contributor
September 6, 2024

@aarthie_ramachandran - if the Inward issue link (blocks) and Inward issue link (Problem/Incident) are only used for projects A, B, and C, you should be able to use the filter...

project = "TKT" AND issueLinkType IN (("Inward issue link(Blocks)","Inward issue link (Problem/Incident)")) AND status != Done

0 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 4, 2024

Hi @aarthie_ramachandran 

This indeed requires an app that can extend JQL options.

I'm in favour of JQL Search Extensions for Jira, I think they offer more functionality.

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira?hosting=cloud&tab=overview 

0 votes
Samuel Gatica (ServiceRocket)
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 4, 2024

Hi @aarthie_ramachandran 

This cannot be accomplished using the native JQL functions, but if you have ScriptRunners installed you can use the linkedIssuesOf function to get all the issues linked. 

Example:

project = TKT AND issueFunction in linkedIssuesOf("project = A AND statusCategory != Done")

 

Hope this helps!

Best regards

Sam

Suggest an answer

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

Atlassian Community Events