JQL - Find stories that were worked on within a date range

[Sajith Jayaratne]

Hi,

I'm trying to create a filter that should show me stories that were worked on for a particular period of time (date range).

I'm currently using - createdDate < endOfMonth(-1) and createdDate > startOfMonth(-1)

But this is inaccurate as it uses the createdDate rather when the work was started. Is there any JQL fields I can run the date range against?

What I want to achieve is to know what stories have been worked on in the last month

Thanks

Saj

[Walter Buggenhout]

Hi @Sajith Jayaratne,

It all comes done on how you define "worked on".

A lot of work does not happen in Jira, so you'll need to figure out how you can identify what you want to see. In many organisations, people log the time they work on an issue in Jira. Others do not, but they update the status of their issues. There are plenty of cases - as a proof of the opposite scenario - where analysts are elaborating stories and update the description of a story, but just to prepare the story for developers to work on it later on. Without questioning the fact that this is work done by an analyst, would you consider this as 'working on a story'?

So, you need to refine your definition first. Once you're they're, you can use things like:

worklogDate >= startOfMonth(-1) and worklogDate <= endOfMonth(-1)

this would be an option if your users log their time in Jira. It might be the clearest way to identify the issues that were actually worked on.

status changed to "In Progress" during (startOfMonth(-1), endOfMonth(-1))

that would take the assumption that an issue being in a certain status means it is being worked on. You can of course include other statuses as well or even omit the status name altogether (just using "status changed during (date1, date2)"),  but being in a status does not necessarily mean that actual work is taking place.

updated >= startOfMonth(-1) and updated <= endOfMonth(-1)

this would select all issues that were somehow updated during the previous month. Yet again, you'll need to ask yourself if you can consider any update to an issue as work taking place.

Hope this helps!