Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to get the value of the lookup table

技術事業群-資料中心營運處-維運整合部-維運一組Jameson_Liu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 16, 2023

I try to use automation to notify google chat post profile as

{
"text":"*SR-OP The following description is not filled:*
<users/{{lookupIssue.opname[assignee.emailAddress]}}>
※ {{assignee.displayName}} {{url}}"
}

The value of opname[assignee.emailAddress] cannot be brought out. I look up the table name as opname and have the corresponding mail value

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 19, 2023

Hi @技術事業群-資料中心營運處-維運整合部-維運一組Jameson_Liu 

Welcome to the Atlassian Community!

Lookup issues is a set of issues, and not just one.  Are you trying to send the list of issues to one person or each one to individuals?  If you want one message for each, consider using a Branch on JQL rather than using Lookup Issues.

Next, referencing the data from lookup issues is the same as for issues.  And so if you wanted to iterate over these, that would be like this:

{{#lookupIssues}}
{{assignee.emailAddress}} : {{assignee.displayName}}
{{/}}

Kind regards,
Bill

技術事業群-資料中心營運處-維運整合部-維運一組Jameson_Liu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 21, 2023

Because I have a lookup table opname, I need to use this variable to bring in e-mail and then bring out my value

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 21, 2023

I am unclear what you mean as your original question references Lookup Issues and now you are referencing Lookup Table, which are two different things in rules.

Would you please post images of your complete automation rule, showing the details of each action, and of the audit log details showing the rule execution?  Those will provide some context to help the community make suggestions.  Thanks!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events