Can you use group by in a send email in automation

Question

Hi there,

Now I know this isn't correct as I am just basically bashing this together trying to see how it might hang together.

I have a scheduled task that is filtered by a JQL statement.

What I am trying to do is send an email that has a heading for each status then the issues at that status under each heading and then loop through.

Is something like below possible in the send email body

Hi Team, Here are the open issues grouped by status:

{{#issues.groupBy("fields.Status")}} 
**Sector: {{key}}** 
{{#issues}} - [{{key}}]({{url}}): {{summary}} 
{{/}} 
{{/}}

Hex.Persephone · Answer

@Alex Ortiz Hi Alex,

I'm trying to use ORDER BY for an automation email

the ORDER BY is in the filter I'm referencing.

the lookup references results from this filter

I'm not having the issues looked up populate in the email with smartvalues I'm using.

can you please advise?

what I'm using in the email template:

Hex.Persephone · Answer

encountering same need as Ste404 @Ste404  @Alex Ortiz

I have 2-3 teams getting a single release notes email automation, and leaders are insistent, it needs to be a single email with each team getting their issues in it's own group (by component).

the orderby isn't satisfying the business need

Alex Ortiz · Answer

But, wouldn't ORDER BY essentially give you a group by?  It's going to display the issues "grouped" by their issue type.