nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Would like to know what the JQL to be for tickets resolved/closed in a certain month

Caroline Feng

Hey team,

I checked and seems like "Issues closed last month" should be sth like this?

Project = yourProject AND resolutiondate <= endOfMonth("-1") AND resolutiondate >= startOfMonth("-1")

https://confluence.atlassian.com/jira063/advanced-searching-functions-683542527.html

Also, I am using the below JQL

Project = xx and reporter =xxx AND status in (Closed, Resolved, Cancelled) AND statusCategoryChangedDate > startOfMonth(-1) AND statusCategoryChangedDate < endOfMonth(-1)

to get the solved tickets for last month only no matter when they were created for team, can you let me know if this should be the most accurate? Just trying to differentiate in which scenario we should use resolved or resolutiondate, or statusCategoryChangedDate

Can you please help me check?

Thanks,

Caro

Accepted answers

Brant Schroeder

@Caroline Feng Welcome to the community.

Use this for resolved issues.

project = XXX AND resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

All comments

Brant Schroeder

@Caroline Feng Welcome to the community.

Use this for resolved issues.

project = XXX AND resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

Caroline Feng

Hey Brant @Brant Schroeder ,

Thanks for your reply.

1. Can you let me know why this is not the ideal one?

Project = xx and reporter =xxx AND status in (Closed, Resolved, Cancelled) AND statusCategoryChangedDate > startOfMonth(-1) AND statusCategoryChangedDate < endOfMonth(-1)

We would like to include all closed, resolved and cancelled not just with 'resolved' tickets in last month only.

2. I also tried syntax Project = xx and reporter =xxx AND status in (Closed, Resolved, Cancelled) AND statusCategoryChangedDate >= 2021-06-01 AND statusCategoryChangedDate <= 2021-06-30 but the results number is different from statusCategoryChangedDate > startOfMonth(-1) AND statusCategoryChangedDate < endOfMonth(-1)? Not sure why this is the case..

Thanks,

Caro

Brant Schroeder

@Caroline Feng

In one you are looking at the status and not resolution. I am looking at the resolution of the issue. I am assuming that all the statuses that you shared have a resolution. So all of those statuses would be included in the query.

Have you identified the issues that are included in one query but not the other? That might give you some insight into what is different.

Caroline Feng

Got it @Brant Schroeder

Just trying to differentiate in which scenario we should use resolved or resolutiondate, or statusCategoryChangedDate AND status in (Closed, Resolved, Cancelled)

Can you please help me on this? Thanks again.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management