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.
