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

Rihab BENYOUCEF April 25, 2024

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.

1 answer

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 25, 2024

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 April 30, 2024

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

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events