Using jql, get list of tasks that were completed yesterday

Question

in jira, the stories are estimated and the team has broken down the story into tasks and each task is set to be complete in 1 day or less.

I want to be able to see

1. All tasks that were completed CurrentDate() - 1

2. All tasks started on CurrentDate()

I am not a jira admin so wont be able to install anything on the server

James_McManamey · Answer

We've written up a post on how you can find yesterday's completed issues in Jira.

https://stratejos.ai/blog/find-jira-issues-completed-yesterday-using-jql/

Also how you can filter the results by the people who completed them. Great for product managers and team leads.

Stratejos  lets you run JQL from Slack and also set up daily custom messages with the results of any JQL.

Chris Nicosia · Answer

@jblue For #1, you can try to use the date the issue was resolved, assuming your sub-tasks' resolution is set at the same time the ticket is moved to your "Done" status.  So something similar to the following:

issuetype in subTaskIssueTypes() and resolved > startOfDay(-1) and resolved < startOfDay()

For #2 this may be a little tricker because it depends on your workflow and there are a few ways to do this.  Here is one way:  If we assume your sub-tasks move from "To Do" status and into "In progress" status when they are started, you could try using this status change date like the following:

issuetype in subTaskIssueTypes() and status changed FROM "To Do" TO "In Progress" AFTER startOfDay()

Keep in mind this list may include tasks that were started and completed in the same day so if you don't want to see "Done" tasks in this list, simply add the following to that query:

and resolution = Unresolved

Let me know if this solution works for you.

Jobin Kuruvilla [Adaptavist] · Answer

Depends on what you mean by task is started and completed. If you have workflow transitions for each, you can do something like this:

status changed from "In Progress" to "Resolved" after -1d

status changed from "Open" to "In Progress" after startOfDay()