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; } } }

[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.

Accepted answers

Hans Polder_7ci2ta

Hi @Michael de Jonge ,

Welcome to the community!

There are two errors in your automation rule:

You've defined 'lookupissues.size' but it should be 'lookupIssues.size' > it at least mattered in my test setup
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:

Screenshot 2024-08-01 105427.png

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.

All comments

Hans Polder_7ci2ta

Hi @Michael de Jonge ,

Welcome to the community!

There are two errors in your automation rule:

You've defined 'lookupissues.size' but it should be 'lookupIssues.size' > it at least mattered in my test setup
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:

Screenshot 2024-08-01 105427.png

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_7ci2ta

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_7ci2ta

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!