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; } } }

JQL Query for tickets marked dev complete last month

Victoria Wiland

I'm trying to put together a query that will pull all the JIRA tickets that were put into a status of Dev Complete during the previous month for our KPIs (e.g. it's now October, I want to see the ones that were marked Dev complete for September).

I have come up with the following query, which meets the syntax requirements, but does not return data:

status changed to "Dev Complete" AFTER startOfMonth(-1m) BEFORE endOfMonth(-1m) AND assignee in (wilanv) ORDER BY created DESC

Accepted answers

Andy Heinzer

The problem here is that your syntax isn't actually looking back -1 month, but rather -1 minute. The 'm' in JQL is in reference to minutes, not months. But within those startOfMonths functions, you don't need the m at all. Instead try using just

status changed to "Dev Complete" AFTER startOfMonth(-1) BEFORE endOfMonth(-1) AND assignee in (wilanv) ORDER BY created DESC

In order to see the issues transitioned to that status by that user last month.

All comments

Mohamed Benziane

Try the keyword "during"

https://confluence.atlassian.com/plugins/servlet/mobile?contentId=267257863#AdvancedSearching-KeywordsReference

Hope this helps

Regards

Andy Heinzer

status changed to "Dev Complete" AFTER startOfMonth(-1) BEFORE endOfMonth(-1) AND assignee in (wilanv) ORDER BY created DESC

In order to see the issues transitioned to that status by that user last month.

Victoria Wiland

Thank you! that worked.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software