Mail a list of issues with assignee name

[Mark Cartwright]

Hello,

I'm looking to send a mail to a distribution list that contains a list of issues from JQL.

Ideally I'd like it to have a URL to each ticket with the assignee name next to it:

JT-1002 is assigned to Joe Bloggs

I'm using this in the body of the mail but it's not putting the assignee's name of each ticket next to it's URL:

{{issues.ToURL}} assigned to {{issue.assignee.displayName}}

Please can someone advise?  I realise this may not be possible yet.

Thanks in advance.

Mark

[Tom Williams · Accepted solution]

Hi @Mark Cartwright, 

I'd tackle this using the lookup issues action. Input the JQL to get the lists of issues you are trying to send and then in the body of the mail include this; 

{{#lookupIssues}}
<li> <a href="{{url}}">{{key}}</a> assigned to {{assignee.dislayName}}
</li>
{{/}}

[Mark Cartwright]

Hi @Tom Williams 

Thanks very much for such a prompt reply.  Sadly this hasn't worked for me. 
I should probably have mentioned we're using Jira Server and no Cloud. 

Would this make the difference?

Thank you.

[Bill Sheboy]

Hi @Mark Cartwright 

Adding on to what Tom suggests, for Jira Server/Data Center automation, the equivalent to Cloud's Lookup Issues is to use a scheduled rule and change the settings to treat the issues as a batch.  Then you can use the {{issues}} (note the plural) the same way as Lookup Issues.

Best regards,
Bill

[Mark Cartwright]

Hi @Bill Sheboy 

That's got it working perfectly.  Thank you very much!  

@Tom Williams Thank you too for the original script!

[Ashu Tyagi]

@Mark Cartwright  Have you tried using "Subscriptions" option for JQL?

You can arrange fields which you want to sent to end users as you wish also if you want to sent results to a Distribution list then you can create a Jira User from that DL and subscribe the JQL with that User

[Mark Cartwright]

Hello @ASHU TYAGI 

Thank you for the suggestion, appreciated!