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

[Bo Schlichting]

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 solution]

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]

Hi Harald

Thanks for the quick reply. :)

I was hoping to get this resolved, without having to buy further apps, with additional cost to the company, as it is a minor need I have at the moment.

So I guess I will live with the manual workaround for the time being.

Best regards

Bo

[Bo Schlichting · Accepted solution]

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. :)