Filter subscription emails are sending incorrect issues with incorrect statuses

[Howard Choularton]

On our system, we have a filter set up to have issues from a specific project, which are of a certain status and are either assigned to them or they are contained in a group custom field value on the issue.

I then have this subscribed for all users. The idea being, that once a week they all receive an email with issues that require their attention.

However, I am finding that the emails sent out by this subscription aren't correct.

The issues in the email seem to have the wrong status, and are being sent in the email when they shouldn't be.

For example, one user should receive an email containing 36 issues (The JQL query and saved filter work correctly inside Jira):

However, they instead receive an email containing 81 issues:

The issues also seem to have the incorrect status reported in the email:

So far, I have tried the following:

• Full re-index of the database
• Deleted the filter and created a new one

Does anyone have any suggestions as to how to fix this issue?

[Brant Schroeder · Accepted solution]

@Howard Choularton 

Looking at the JQL the emails to each user will differ.  I have never heard of the filter results being different than what is in the email.  If you run it for yourself is your email and filter results matching?  

[Brant Schroeder]

One other question do you have a test or dev instance that is synced off of the production instance. I have seen emails come from these instances and confuse users because the information is outdated and wrong.

[Howard Choularton]

Ah - good idea. Yes we have a dev instance, maybe this is interfering. I will disable it and see if we find an improvement.

Thanks

[Norbert Grzebieniarz]

@Howard Choularton my users have same problem. Filter in jira returns 8 issues, and subscription returns 68 issues via e-mail.

I have only prod instance, so there is no way to receive outdated e-mails.

I'm running old Jira Software 7.3.6

[Brant Schroeder]

@Norbert Grzebieniarz is it 8 for everyone in the search and 68 for everyone who is subscribed?

[Norbert Grzebieniarz]

I think i have found the issue. It looks like that the subscription was also sent from my dev instance. But still waiting for the users response.

[Frithjof]

We are getting a somewhat similar error, a user is subscribed to a filter:

However he is still receiving mails about an issue which is not in that filter for almost a year, (status = Done since May 2021).
In the Email the status of the Email is still displayed as "Open".

Many many reindexes have been happening already in the meantime, but the issue still seems to be occuring.

@Howard Choularton how did you get your issue resolved?

[Brant Schroeder]

Do you have a test instance?  We had a user that was getting emails from the test instance but thought it was production.

[Frithjof]

Yes we do, but the mails come from Prod instance for sure.

We introduced different mail subject prefixes, so we wouldn't mischange :)

[Brant Schroeder]

Is that issue also resolved in the test instance?

[Frithjof]

Dont really understand how it is related, as the Email is clearly coming from the prod instance, but yes, also there on the test instance it is resolved.

[Frithjof]

One more screenshot to illustrate the problem more:

[John M Funk]

Hey @Howard Choularton and @Norbert Grzebieniarz 

Did you ever get this resolved?

[Howard Choularton]

I think so, yes.

[John M Funk]

Great!