To add to the other answers, you need to understand your workflow. I wouldn't have thought that In Progress is your first status - generally when an issue has been reopened, it will move to a status of Open or Reopened, so the JQL query would be
projecy=XYZ and status changed to Reopened
You need to replace the word Reopened above with whatever status your workflow shows when you reopen an issue.
@kunal kandpalIt depends what status you have defined as re-open normally you can Just type the JQL query on search issues box if you have the re-open status for reopened issues in your workflow.
status = reopen then click search for issues button.
Hi @kunal kandpal, If you are trying to find all issues that were ever Re-opened, irrespective of what their current status is, you should try using 'status was Reopened'. This could change based on the statuses defined. You could also try - 'status was Resolved AND status changed to ...'.
Hope this helps!
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events