Jira JQL for issue on different project

Question

Hello there,

Im not that good with Jira JQL but i have a question.
We would like to have a que in our servicedesk project that is showing tickets older then 7 days, which have not been updated (off a different project, that are linked issues).

So we have an ITSD en WBENG board.

I now have this:

status = "Waiting for change" AND "Solution group" in (Engineering, "Applicatiebeheer Afas", "Cyber Security", Development, "Development Bridge", "Development Support Walfis", "IT KNS", "Nedlift functional management") AND updated <= -7d AND status != Resolved AND status != Closed

Which works, but only for the project that we are in (ITSD) but I also want this rule to check the linked issues in all of the solution groups.

Thanks in advance

Trudy P Claspill · Answer

If you want a queue that lists ITSD issues where the status of a linked issue has changed or a comment has been added to a linked issue in the past X days, there are two ways you can achieve that.

1. Acquire a third party app that will extend JQL capabilities that will enable you to execute filters for issues based on changes to linked issues.

2. Create Automation Rules that will update the ITSD issues when specific changes occur in the issues linked to them. For instance, you could keep a custom date field in the ITSD issue. You could create an Automation Rule that is triggered when a comment is added to a WBENG issue. In that rule you would check to see if that WBENG issue was linked to an ITSD issue. If it was, then in the rule you would update the custom date field in the ITSD issue. Then your Queue filter could look for ITSD issues with that custom date field within (or outside of) your specified date range. You could create a similar rule for when the Status changes on a WBENG issue.

Erik Boneschansker · Answer

Thanks Trudy,

For now I will leave the post open to see if others might have an idea.

(Its not about the details)

I don't want to see the input of the linked issue, i just want to see if the status is changed or these is a comment added. (and not litterly see the comment)

Just a que that gives a sign that the linked ticket is changed

Trudy P Claspill · Answer

Hello @Erik Boneschansker

If you want to show in the ITSD project queues the details of WBENG issues, that will not be possible.

If you want to show an ITSD project queue that lists ITSD tickets, where those tickets are linked to a WBENG issue, and further constrain the list of ITSD tickets by applying criteria to the linked WBENG tickets, that may be possible with a third party app. It would not be possible with only the native Jira JQL capabilities.