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

Automation: Lookup, Email, Smart Values

Fred_agblkk

Good day!

I have an automation to run every month, that successfully looks up issues and emails them to me. The data I'm sending will eventually end up in a gsheet. I'm getting tripped up on the smartvalue syntax.

{{#lookupIssues}}
{{key}}, {{issue.customfield_13264.description}} 
{{^last}}
{{/}}
{{/}}

Key/comma/linebreak are perfect. How do I get custom field values? None of the permutations I've tried works.

Thanks for your wisdom!

Accepted answers

Sue Wilson

@Fred

Have you already tried:

{{customfield_13264.value}}

{{issue.customfield_13264.value}}

All comments

Sue Wilson

@Fred

Have you already tried:

{{customfield_13264.value}}

{{issue.customfield_13264.value}}

Fred_agblkk

The first works! Is that the syntax for lookupIssues, leave off issue.?

I understand that {{/}} closes the #lookupIssues. Can you explain what this is saying?

{{^last}}
{{/}}

Sue Wilson

Glad it works!

You are looking up a list of issues. The fields you want to display are the key and the customfield. Since you already have an issue in context based on your query, you do not need to prefix the smartvalue with "issue.". That is why you have {{key}} instead of {{issue.key}}.

{{/}} - effectively closes the lookup issue after all issues from the query have been identified.

Additionally, using ".value" instead of ".description" brings the custom field value into the results, as expected. Description would bring back the description provided in the custom field's configuration, if any, which does not give you what you are looking for. I hope this helps!

Fred_agblkk

Perfect! I appreciate the help.

Bill Sheboy

Hi @Fred

The {{^last}}something{{/}} structure allows you to conditionally do things inside of the list iterator. For example,

{{#lookupIssues}}{{key}}{{^last}}, {{/}}{{/}}

Will add a comma after each key value except for the last one; that is what the ^ last represents: not last.

Please refer here for more information on other operators for list management: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#Combined-function-examples

Kind regards,
Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud