I want to write JQL to search for a date that changes to a specific state, but I don't know how to write it.
Hi,
JQL has functions that are useful for date range search, such as startofday(), endofmonth(), and these functions can take parameters, such as startofmonth(-3), which gives you everything regarding 3 months ago.
I'm not sure what you mean by 'state', as I'm in Australia, and state is the area of the country?
Happy to get more details?
Mark
Thank you for your reply, Mark."STATE" I meant "STATUS" in JIRA.If there is data that has been moved to STATUS in the past, not the data currently in STATUS, I want the date when that data was moved.
Hello @양재석
I don't think you can use JQL to get the information you want. JQL is used to find issues.
So to find issues that moved to STATUS on a specific date, you'd write
status CHANGED to <STATUS> ON <DATE>
You were rightThank you so much!He saved me!
Hi @양재석
JQL works with WAS or CHANGED operators to find status changes. Here you can try something like:
status CHANGED TO "Done" DURING ("2023/03/01","2023/04/01")
I'm not sure if you can search for the date when the issue changed its status.
Maybe this article will be helpful, too:
6 simple options to track status changes in Jira
Happy to hear! If you're all set, go ahead and mark the question as answered with accepted answer(s).
It looks like you're new here. Sign in or register to get started.
