Hi - I am trying to setup an automation that lists out all linked issues in a comment on the ticket. I'd like those issues to be clickable (i.e. not just the text but an actual URL). I found a few examples in the community using Lookup Issues and thought the below would work (at one point it did work but I can't seem to get it worked again!). The steps I have are * When issues is transitioned to a specific status * Then Lookup Issue (using the JQL below) issue IN linkedIssues("{{issue.key}}") * And Add a Comment (using below format) View linked issues below {{#lookupIssues}} * {{key}} {{/}} This automation runs successfully and it adds the comment but it doesn't insert any issues into the comment, even though there is a linked issue on the ticket. On the audit log, there is a message that says "A search during custom value definition found no issues." If I do a Jira search using the JQL but replacing the {{issue.key}} with the actual issue key, it returns all the linked issues fine. I've also tried triggering this automation manually and it doesn't work either. Any help would be appreciated!

I agree with @Tomas Slavkovsky, I think this is a bug in the JQL handling. I'm running a rule that does a lookupissues running this query: Project = XXX AND issueFunction in completeInSprint({{Sprint.originBoardId}}, '{{Sprint}}') When the rule runs, I have it print the above statement into the audit log, and at that point the JQL it sees looks like this: Project = XXX AND issueFunction in completeInSprint(9843, '2022.PI2.S10') When the rule executes, I get a message saying "A search during custom value definition found no issues." However, if I run the "translated" JQL (shown in the audit log) in an issue search, it returns 3 issues, which is the expected result. * All of my issues are in the same project. * If I change the lookupissues to "Project = XXX and status = Done and Sprint = {{Sprint}}" it returns 3 issues, as expected. To narrow things down, I tried: * "Project = XXX and issueFunction in completeInSprint(9843, '{{Sprint}}')" to see if it was multiple smart values causing the issue, but that also failed with "A search during custom value definition found no issues". * I even took all of the smart values out and replaced them with actual values, and it still failed. The introduction of a Scriptrunner function (I've tried several others with the same results) seems to be causing the problem for me.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List linked issues in comment

JD_uvea3n

Hi - I am trying to setup an automation that lists out all linked issues in a comment on the ticket. I'd like those issues to be clickable (i.e. not just the text but an actual URL).

I found a few examples in the community using Lookup Issues and thought the below would work (at one point it did work but I can't seem to get it worked again!).

The steps I have are

When issues is transitioned to a specific status
Then Lookup Issue (using the JQL below)

issue IN linkedIssues("{{issue.key}}")

And Add a Comment (using below format)

View linked issues below

{{#lookupIssues}}
* {{key}}
{{/}}

This automation runs successfully and it adds the comment but it doesn't insert any issues into the comment, even though there is a linked issue on the ticket.

On the audit log, there is a message that says "A search during custom value definition found no issues."

If I do a Jira search using the JQL but replacing the {{issue.key}} with the actual issue key, it returns all the linked issues fine.

I've also tried triggering this automation manually and it doesn't work either.

Any help would be appreciated!

Accepted answers

All comments

Eric_nrqbhg

Hi @JD

On a cursory glance, I can't see anything wrong with the rule you described. I also find it weird that the audit log says no issues but searching manually returns some results.

Are you able to take a screenshot of your rule and the audit log?

Cheers,

Eric

JD_uvea3n

Hi @Eric - thanks for the reply.

I've inserted screenshots below (this is a copy of the original issue but same issue is occuring).

Setup below

CleanShot 2022-05-27 at 07.49.51.png

CleanShot 2022-05-27 at 07.50.03.png

Here is the audit log. Note that it is 'successful' but the lookup fails to find any issues.

CleanShot 2022-05-27 at 07.57.58.png

Here is an issue where I've run the automation (relating to the audit log above). Note the existence of a linked issue and the comment is added, but nothing is linked.

CleanShot 2022-05-27 at 07.55.35.png

Vanjinathan Ramalingam

Hi JD, Did you manage to get the solution? Im also looking for a solution to

List linked issues in comment.

Tomas Slavkovsky_otdinv

IMHO, the problem is in the lookupissues JQL because in the audit log, you can see:

"A search during custom value definition found no issues."

Meaning there are no entries for this JQL query.

Marco Augusto Santinho Gonçalves

just use {{issue.issuelinks}}

Sam Katz_dvudy9

Hi @Marco Augusto Santinho Gonçalves thank you for this, do you know if this can be used to include the URLs of the linked issues as well? I tried a few combinations such as

but those did not seem to return any value.

Any ideas?

Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

automation