Forums

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

Lookup issues then create a table with links to the issues

EH
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 8, 2024

Hi, I'm looking to create an email which does a lookup issues:

status != "done" and duedate = now()

Then creates links to the tasks found in the lookup so they can be emailed out.  I am not certain how to take the data I'm returning and get it to format the tasks to include the links, rather than just plain text.  Full-on newbie with JQL and smart values. 

Any help would be appreciated. Screenshot 2024-08-08 115831.png


Screenshot 2024-08-08 115850.png

1 answer

1 accepted

2 votes
Answer accepted
Christopher Yen
Community Champion
August 8, 2024

Welcome to the community @EH !

So I've done this but instead of table I generate a bullet point list in an email, I'll include my email formatting below so you can use it as a reference

Good morning, the following tasks are due today
<ul>
{{#lookupIssues}}
<li><a href="{{url}}">{{key}} : {{Summary}}</a></li>{{/}}
</ul>

2024_08_08_12_06_10_Window.png

EH
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 9, 2024

That worked perfectly, thanks Christopher!  Interesting formatting.

Like Christopher Yen likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events