JQL how get resolved issue ?

Question

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 Answer

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_2nfdtf · Accepted Answer

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