Find changed status from ANY status to a specific one in the past week

[GabrielleJ · Accepted solution]

There are many ways to accomplish this, the best option I can think of is "CHANGED"

https://confluence.atlassian.com/jira/advanced-searching-179442050.html#AdvancedSearching-CHANGED

[Alex Benavides]

There is an issue in Atlassian Answers, it doesn't let me add a descrption

I want to make this more effective

project = "Feature Requests" AND component = "Ads Workflow" AND (status changed FROM "New" TO "Accepted" after -60d) OR (status changed FROM "Postponed" TO "Accepted" after -60d) and type != Epic ORDER BY created

I am already useing changed

[Alex Benavides]

With the declaration above, I get 19 issues

With this one I get 5

(status changed TO "Accepted" after -60d)

[Ignacio Pulgar]

Try adding Project="Feature Requests" again after the OR.

[Ignacio Pulgar]

Trying the two JQL queries (those separated by the OR) independently usually helps.

[Ignacio Pulgar]

Reading the link on your question about votes, read the sympthom 2.

It seems that your workflow is not properly set, and is causing weird behaviour on JQL queries too.

In this case, I would try to build a new workflow from scratch.

[Alex Benavides]

status changed TO "Accepted" after -60d worked for me. When I took a closer look into the results, I noticed that I was seeing the right information, Thanks everyone

[GabrielleJ]

Glad to have helped!