Is there a way to exclude linked tickets/work that have been marked as done?

[JoAnn Pruden]

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
Ready for Acceptance	CCS-6685	CS-8419	Conrail: J McCrear stuck on FD22
Customer Acceptance	CCS-6682	CS-8415	GWRR: Maldonado-Ocasi & Allard - Clock out issue
Ready for Acceptance	CCS-6681	CS-8413	GWRR: HURON CENTRAL RAILWAY - Gregory Beharriell UNABLE TO CERTIFY RECORD
Ready for Acceptance	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.

[Olha Yevdokymova_SaaSJet · Accepted solution]

Hi @JoAnn Pruden

 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.

✅ Workaround Options

1. Use Automation to Tag the Parent Issue

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.

2. Try the Forge Apps Generator

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!

[JoAnn Pruden]

Thanks!  I'll try that. :)

[Aaron Pavez _ServiceRocket_ · Accepted solution]

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

[JoAnn Pruden]

Thanks!