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.

[Aaron Pavez _ServiceRocket_]

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