JQL to locate tickets, where the linked ticket from another project is status Done

Question

Hi

I work with Service Desk as one project "MSSD".

Then do we have a "TECH" project, where the bugs are resolved.

Customers crate a MSSD incident and IF we find that it is a bug, do we create a TECH ticket, for the TECH team to resolve.

I want to create a filter, where I can see the MSSD tickets, which have linked TECH tickets which is in status "DONE".

I have tried with the linkedIssues, but it seems to need a specific ticket number.

I have searched, but has not been able to find a solution.

Best regards and thanks

Bo

Harald Seyr · Accepted Answer

Hi @Bo Schlichting

there are a couple of ways to solve this, e.g. by

using the ScriptRunner plugin, see

* How to search for issues that all linked issues ar... (atlassian.com)
* Solved: Filtering based on linked issue status (atlassian.com)

using the JQL booster pack, see

* Solved: JQL: query for a specific linked issues status (atlassian.com)

Regards,

Harald

Bo Schlichting · Accepted Answer

I managed to do it with  the following filter:

(project = Tech or project = Development) AND (creator = 61234e51fc55090071e1f843 OR creator = 62ea56a6825fbfbfcff094c6) and status = Done and updated > endOfDay(-14) ORDER BY updated DESC, cf[10547] DESC, created DESC

This filter gives me the Tech or Devel tickets which is closed within the last 14 days. :)