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]

@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