Hello @mohamedrabeek.jabarulla
Jira does not natively support a method that would give you those results.
First, Jira does not record the date of each status change in a manner that you can query. You could create a custom field for recording the date of the transition and use an Automation Rule to populate the field. Or you could look for a third party app the would help you build Queries about status transition dates.
Second, Jira does not support JQL to build a query that allows comparing one field to another
To meet that requirement would require a third party app.
Are you willing to consider getting third party apps to meet your needs?
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.