Jira Automation to reassign the reporter field when a user is leaving

[Michael Savedra]

Hi!

I'm trying to create an automation that, when a new ticket is created, will search for all related open tickets that have the reporter as the same value as a customfield in the new ticket ("Leaver Email"), find their manager from the custom field "Leavers Line Manager" and then update the reporter on the linked issues to change it to the line manager from that custom field. 

I'm very stuck with how to achieve this. I know I'd need to use the Branch Rule and then maybe the Lookup Issues action but I'm not sure how I'd format the JQL required. 

EG: For related issue JQL - "reporter = {{triggerIssue.fields.customfield_1234}}" > Action - Update Reporter to {{triggerIssue.fields.customfield_4321}}

Please let me know if I need to elaborate any further.

Thanks in advance! 

Mike

[Michael Savedra]

I found the answer was to use this in the jql: 

reporter = {{triggerIssue.fields.customfield_20881}}

then edit thge related issues with the following:

{
"update": {
"Reporter" : [
{
"set": {
"id":"{{triggerIssue.NGSD: User to transfer docs to (Free Text).accountID}}"
}
}
]
}
}