JQL how get resolved issue ?

[Alex]

Hello everyone! how to make a request JQL to get the number of tasks solved 1,2,3,4-15 days ago ?

my task is to upload csv the report(with python) for two weeks, the report will indicate the number of tasks solved for the 1st, 2nd, 3rd day and up to the 15th day (end of the week)

[Mark Segall · Accepted solution]

Hi @Alex - You should be able to get that information with this JQL:

Resolved IS NOT EMPTY and status CHANGED AFTER -15d

This will bring in everything resolved over the past 2 weeks.  If you want to be more explicit, you'd just execute individual queries for each of the parameters you're looking for.  For example here's 1 day ago:

Resolved IS NOT EMPTY and status CHANGED AFTER startOfDay(-1) AND status CHANGED BEFORE startOfDay()

You would just change the days for each subsequent query to meet your needs.

[Alex]

@Mark Segall Hello! Thanks a lot for the tip!

[Alex · Accepted solution]

SOLUTION!!! The following JQL query worked for me :

Search tasks for "yesterday": 

project = "YOUR PROJECT" AND resolved >= startOfDay(-1) AND resolved <= startOfDay()

Search tasks for "the day before yesterday" 

project = "YOUR PROJECT" AND resolved >= startOfDay(-2) AND resolved <= startOfDay(-1)

Search for issues "solved 3 days ago"

project = "YOUR PROJECT" AND resolved >= startOfDay(-3) AND resolved <= startOfDay(-2)

and so on

[Aron Gombas _Midori_]

Alternatively, you could a n Excel report like that with this app:

https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=server&tab=overview

You export all your issues and don't forget to include the Resolution Date field in the export. You can then easily add a new column which calculates on which day of your interval the given issue was resolved. Then you can just create a pivot table by counting the occurences of the "1st", "2nd", ... day resolved issues.

(Disl. it's a paid and supported app developed by our team.)