Find out the issues/stories/sub-tasks which I worked only on the weekends in last one year.

Question

So I need to provide the list of tasks which I worked over the weekends and update the status to Dev Complete or QA in last one year.

This is my current filter -

status in ("In Development", "In QA") AND resolved >= 2019-01-01 AND resolved <= 2019-10-22 AND assignee in (currentUser()) order by created DESC

Haran Kumar · Accepted Answer

Hi @Hemang Shah

If i have understood you correctly,

To check for the tickets  that you have changed to Dev completed or QA , the following JQL can be used ,

status changed TO "DevCompleted" OR status changed TO "QA"  AND assignee was in (ur_name).

To check for weekends task

updated >= startOfWeek('+5d') AND updated <= endOfWeek().

Assuming Saturday and Sunday as your weekends. If its only Sunday then use  StarOfWeek('+6d') .

Currently out of box you cannot get this data on cumulative basis for the whole year. You have to use any available plugin or write own code using script runner to achieve the required output.

Hope i answered your question.

Regards
Haran