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

[Andy Heinzer · Accepted solution]

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.

[Victoria Wiland]

Thank you! that worked. 

[Mohamed Benziane]

Try the keyword "during"

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

Hope this helps

Regards