I have a dashboard listing tickets in "Customer Acceptance" and I would like to exclude tickets where the linked work/ticket has been marked as done.
Currently, it looks like this:
Status
Links
Key
Summary
Ready for Acceptance
CCS-6720
CS-8463
Transtar: UAT Password Reset
Customer Acceptance
CCS-6702
CS-8446
Transtar: Jobs not showing vacant
CCS-6685
CS-8419
Conrail: J McCrear stuck on FD22
CCS-6682
CS-8415
GWRR: Maldonado-Ocasi & Allard - Clock out issue
CCS-6681
CS-8413
GWRR: HURON CENTRAL RAILWAY - Gregory Beharriell UNABLE TO CERTIFY RECORD
CCS-6673
CS-8405
GWRR: Remove HOS Record 7/27/25 - Leonard Ricky-013073
I would like to exclude all the work items where the links are closed. In this case, only the last item with Key CS-8405 would appear.
Hi @JoAnn Pruden
I couldnt find how to do it with out-of-the-box JQL. You can use Scriptrunner or JQL extensions app to have access to linkedissuesstatus or similar function.
For example:
and createdDate >= startOfMonth() AND (issueLinkType = "relates to" AND linkedIssueStatus = Done)
Will list all work items from the beginning of the month with the link relates to and status of that linked issue is Done.
If you don't have Scriptrunner or JQL extensions, the best way to filter is to add a custom field or label to a linked issue that is in Done status.
Regards - Aaron
Great question — this is a common challenge when working with dashboards and linked issues in Jira.
Unfortunately, JQL (Jira Query Language) doesn't currently support filtering based on the status of linked issues out of the box. That’s why your dashboard includes items where the linked tickets are already marked as Done.
One approach is to create an automation rule like:
Trigger: When a linked issue is transitioned to Done
Condition: Link type is “is blocked by” or similar
Action: Add a label or update a custom field on the parent issue
Then in your dashboard, you can filter out issues with that label or field.
If you’d like something more automated and visual, you can use a tool like Forge Apps Generator deceloped by my team to create a custom dashboard gadget or app that does exactly what you’re describing.
You just describe what you want, like:
“Create a gadget that shows only issues in Customer Acceptance where all linked issues are not Done.”
The app is generated and deployed into your Jira — no coding needed. It's a great way to handle more complex reporting needs when native Jira filters fall short.
Let me know if you'd like help drafting the exact prompt or testing it out!
Thanks! I'll try that.
Thanks!
It looks like you're new here. Sign in or register to get started.