Translate Reporter_Account_Id

jeff.rhoad

Is there a way to translate the jira_issue.reporter_account_id to the object key of the reporter in asset_object table? 

I am trying to create a list of tickets reported by location and I need the object key of the reporter to determine their location. 

Thanks. 

Rodney Dsouza _Atlassian Certified Expert_

First do a 'Lookup Objects' call first for schema = People and the query  is User = {{issue.reporter}}

Then you can used the resulting Lookup object/s  (in above scenario it would be called 'User').  So, you could print out the results, say as Comment or Log action, using code like this:

reporter ID = {{issue.reporter.accountId}}
{{#lookupObjects}}
* {{User}} , {{User.displayName}} , {{User.accountId}} 
{{/}}

For me the results look like:

reporter ID = 6406540e9ce2cd2c240fc14c

• 6406540e9ce2cd2c240fc14c , Rodney D'Souza , 6406540e9ce2cd2c240fc14c

As you can see displayName and accountId keywords you can use.

 

If this helps, let me know, and 'Accept' this answer