Inconsistent Results with Jira Cloud Filter for Status at Start of Month

[Rihab BENYOUCEF]

Hello, we've been encountering an issue on our Cloud instance where we're trying to create a filter that shows issues in specific statuses ("in progress", "To Do", etc.) at the start of the month. For example, at the beginning of April, we want to see all issues in status ("in progress", "To Do").

Previously, when using Jira server, we used this JQL request:

```
project = "Suivi des demandes IPA" AND issuetype in (Accès, Bogue, Documentation, Evolution, Exploitation, Formation, "New Feature", Support, Task) AND status WAS IN ("In Progress", "To Do", "In Review", "En Attente d'approbation", "Waiting for customer", "En attente correction", "En attente mise en production") on startofmonth() ORDER BY KEY ASC
```

And it worked correctly. This filter gave us all issues that were in the list of statuses at the start of the month.

Now, with Jira Cloud, this filter gives us incorrect results:
- It includes all issues that have had one of the listed statuses in their history, even if they are not currently in those statuses.
- Issues that have been in status "To Do" since their creation (without any changes) are not included in the results.

[Bill Sheboy · Accepted solution]

Hi @Rihab BENYOUCEF 

There are at least two open defects in the public backlog for this symptom:

https://jira.atlassian.com/browse/JRACLOUD-70797
https://jira.atlassian.com/browse/JRACLOUD-81443

I would expect the impact to be worsen if anyone has created a team-managed project in your Jira site.

If the symptoms you see are different, I recommend working with your Jira site admin to submit a ticket to the support team here: https://support.atlassian.com/contact/#/

Kind regards,
Bill

[Rihab BENYOUCEF]

Hi Bill,

Thank you for sharing the links. It appears that the issue we're encountering is connected to the first defect (https://jira.atlassian.com/browse/JRACLOUD-70797).

I will reach out to the support team to assist in resolving the issue.

Thanks for your assistance.

Best regards,
Rihab