Automation sending emails to me but not others from the query

[Ed Hunnell]

I am trying to setup a simple automation that runs every night. The query produces a list of all Jiras that are past their due date or have not been touched in the last 7 days (screen shot below only shows part of the result of this query). The automation running every night seems to works as well as triggering it manually. And the query works.

The output/action of the automation is to send an email to each assignee with one of these tickets. The issue is that I have one ticket assigned to me that is late. There are 9 other jiras in this query that are also late. And I get an email from this automation. But no one else gets an email. When I look in the logs, I see the email to me but no attempt to send emails to anyone else who owns one of the jiras in the query results. Here are some pictures with some data redacted.

Why am I the only one getting this email? Thanks for your help.

Ed

Ed Hunnell

[Nic Brough -Adaptavist-]

A Jira query finds issues, not projects, so it's probably already giving you the right answer.

I'd summarise probably.  Save your filter, create a dashboard, and add a "filter statistics" gadget to it.  Select your filter and the "field" called Project.  You'll get a bar chart listing the number of issues in each project.

[Casey Maynard]

The only solution I have found is to limit the table results to 1.

[Alexey Matveev]

Hello,

How to make the query? Rest Api?

[Casey Maynard]

Just using the Issue JQL Search page.

I know it is giving me the results it should be but I want to filter it down to only show 1 results if there is more than 1 results.  Similar to the Excel 'unique records only' option.

[Nic Brough -Adaptavist-]

The way to get a unique record with JQL is to filter it down to just the one single unique issue you want to see.

The result in JQL is a list of issues that already gives you "unique records only" - each issue returned is unique.

I suspect I am missing something here, as it sounds like you are looking for a single result from a search that could be returning many, but I don't understand why you only want a single result, or which one to pick when there are many.

[Casey Maynard]

I think the terminology that I should have been using is 'returning many', but I only want one 'example' of 'the many' listed.  As all of the results have the 'same' answers, but I only need to see one.  Is there a way to see this single result?

[Alexey Matveev]

There is no way to see only one example of the many listed in JQL.