nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem tracking issue status changes via JQL on Jira Cloud

Dave Rench McCauley_f1k8vk

Hello,

I’m having trouble with a JQL query. I’m trying to setup a Confluence page to return issues that were completed in the last month (which I’m willing to define as 30 days since it doesn’t seem like JQL has a months capability). To that end, my JQL statement is:

project="XX" AND status CHANGED TO "Done" AFTER -30d

but this consistently returns zero results, even though I have an issue that qualifies. If I remove the TO criterion like this:

project="XX" AND status CHANGED AFTER -30d

it seems to work. If I try:

project="XX" AND status CHANGED TO "Done"

it also fails to return any results. Oddly enough, that last queries fails to return any results for any status other than "To Do", and even that one only returns my Epics for some odd reason. What am I doing wrong?

Note that this is a next-gen Jira project, if that matters.

Accepted answers

Liam Green

Hi @Dave Rench McCauley

Welcome to the Community!

Jira does use months, but only in terms of this month, or last month, etc.

Can you try the below and see if it is what you need?

project = XX AND resolution date >= startofMonth ("-1") AND resolution date <= endofMonth ("-1")

This should show all tickets resolved in October.

All comments

Liam Green

Hi @Dave Rench McCauley

Welcome to the Community!

Jira does use months, but only in terms of this month, or last month, etc.

Can you try the below and see if it is what you need?

project = XX AND resolution date >= startofMonth ("-1") AND resolution date <= endofMonth ("-1")

This should show all tickets resolved in October.

Guilhem Dupuy

Hello,

Indeed, this is weird because this should work (I does work in my instance).

Are you sure that "Done" is the right status name ? Which statuses does Jira propose when you're building your search ? If it is the right status name, I suggest you to raise an issue from the Atlassian support portal (Suggestion and bug reports) :

https://support.atlassian.com/

Dave Rench McCauley_f1k8vk

Thanks for testing that! I did indeed use the Advanced Search functionality in Jira so that it would auto-suggest status strings and Done was in there (and I selected it, just in case I was having a whitespace issue). Still no dice. I'll submit it as a bug then.

Dave Rench McCauley_f1k8vk

Thanks @Liam Green ! I was able to get it to work by slightly modifying it (since I wanted the changes to be for November instead of October, although when I generate the report will obviously impact that...) to

project = "XX" AND resolutiondate >= startofMonth () AND resolutiondate <= endofMonth ()

But of course the downside here is it only works for resolved issues and doesn't explain the larger issue of why I can't do this with statuses alone (even if Done + resolved were some unique status, which I don't think it is, it should be able to work for ones that changed to "In Progress" for example).

Dave Rench McCauley_f1k8vk

@Guilhem Dupuy Disturbingly, I can only submit a proper bug report if I pay for Jira. As I'm currently testing it out for a small team with a free account, I can't file the bug. Super odd approach, Jira.

I did manage to find my way on to the engineers' Jira board for Jira (super meta!) and seem able to submit a bug that way, but I don't know if they'll see it...

Liam Green

I've just done a little work on it on my instance, can you try:

project = XX AND status changed TO Done AFTER startOfMonth() BEFORE endOfMonth()

That just worked for me (although I don't have a 'done' state, I have 'resolved')

Dave Rench McCauley_f1k8vk

Sadly no, this doesn't work.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud