Lookup issues based on custom user picker field

[Geza Kukoda]

Hey there,

I have a request type for leaving employees where I use a user picker (custom field) to define the employee who is leaving.

When the ticket is created I would like to have an automation which links all the issues where this user was the reporter to this leave ticket.

I have tried to use the Lookup issues function to list all the tickets where this defined user was the reporter but it didn't accept the filter I have put it.

reporter = {{issue.Employeename}}

Employeename supposed to be the custom field with user picker type. The Validate query is even greyed out.

There is some hint on the page that I should use user IDs.

I would be thankful for any help.

Best,

Geza

[Bill Sheboy · Accepted solution]

Hi @Geza Kukoda 

If Employee Name is the name of your field, please try this for the Lookup Issues JQL

reporter = {{issue.Employee name.accountId}}

And the "Validate query" option is grayed out because your JQL is based upon dynamic information the rule supplies at run-time, and it cannot be checked as the rule is defined.

Kind regards,
Bill

[Geza Kukoda]

Hey Bill,

Thanks for the prompt solution. It worked. :)

Best,

Geza

[Piyush A (STR) · Accepted solution]

Hi,

Probably to get the custom field value, you might need to use like below:

${issue.fields.customfield_10051}  or ${issue.fields.customfield_10051.accountId}  

here put the custom field id 

(get it from <url>/rest/api/2/issue/issue key/ and search for the data of the field and get the custom field id)

also, kindly go through https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/

[Geza Kukoda]

Hey Piyush,

I am working with the automation page on the settings and not with the API. But sure thing the .accountID was the missing point.

Thanks for replying.

Best,

Geza