[Solved] Lookup other issues for assigned assignee

[Michael de Jonge]

I'm currently making my own Out of Office function. When a issue is assigned to someone i want automation to look for another issue called "Out of Office".

Currently my automation is giving errors in the lookup function. Can anyone help me with the right JQL code for this.

[Hans Polder · Accepted solution]

Hi @Michael de Jonge ,

Welcome to the community!

There are two errors in your automation rule:

1. You've defined 'lookupissues.size' but it should be 'lookupIssues.size' > it at least mattered in my test setup :)
2. You cannot use 'smart values' directly in a JQL. You need to define it as a variable first.

TIP: Use Log actions in your automation rule to see where it's failing.

Below automation works for me:

PS: The log actions are of course not needed once the rule is working fine, you should either leave them out, or remove them once the rule is working correctly.

[Hans Polder]

PPS: I assume that you're either deleting the out of office tickets, or making them 'unassigned' after the person has returned from out of office > otherwise the script will always work for any past ticket as well. Or you should add some JQL logic like 'and status != Returned' to avoid past OoO's to be activating the rule.

[Michael de Jonge]

Hi Hans, thanks for you clear explanation. I already fixed the assignee wich was a problem of adding "" around the {{}}.

And thanks for the capital I in lookupIssues, that also solved a problem.

Somehow i didn't need to add all the smart values and I AM able use them directly.

The working script for now:

Thanks again for you help!

[Hans Polder]

Ah, cool! I learned something new today :)

Of course, all the 'add to audit log' entries were not needed, but good to know that you actually don't need to create the variable and just add the "" to make it work!