In Jira Cloud JQL can I query for tickets that have time logged prior to the open sprint?

Jon Platt

I have a requirement to identify tickets that have had no time logged in the current sprint. Finding tickets with no time logged at all is easy but some tickets may have had time logged prior to the start of the sprint.

So, in Jira Cloud and JQL can I query for tickets that have had time logged but that time is not logged in the open sprint?

Something like

timespent is not empty and not in (worklogDate > startOfSprint(openSprint())

I understand that that I can define a filter that excludes the content of another filter but I can't find a way to programmatically obtain the sprint start date. startOfSprint is not a real function (despite Copilots recommendations!).

 

Trudy P Claspill

Hello @Jon Platt 

The short answer is you cannot achieve that with only the native JQL capabilities.

It might be possible to achieve it with the help of a 3rd party app.

Are you open to considering getting a third party app to meet your needs for this report?

Or it might be possible to achieve with an automation rule that prompts for the sprint ID and then takes various actions that might include calling the Jira REST API.

 

It should also be noted that there is an openSprints() JQL function that is native, but that gives you all open sprints, not a single open sprint.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#openSprints--

There is no native function that will dynamically give you a single open sprint.

The first hurdle is in dynamically identifying the one sprint you care about. You would first have to identify the Scrum Board from which you want to collect the sprint. There is no JQL function to request open sprints from a specific board. And then there is the possibility that Parallel Sprints is enabled and there is more than one open sprint for that Scrum Board. In that case how would you tell Jira which of the open sprints is the one you actually want?

 

Stepping back, what problem are you actually trying to solve, where you think getting such a report is going to help you solve the problem?