Help with JQL syntax

Question

How to find all issues created as P8 and whose priority changed within 24 hours of creation

Aron Gombas _Midori_ · Answer

If you are open to using an app, then our Better Excel Exporter app can export the full change history to a spreadsheet like this:

Then, you can use the Excel features to analyze the data.

For example, you original request could be solved like this:

* Export nothing else, but the issue key, summary, creation date with the "repeating change history" template
* Then add a new column in the right, with a formula which evaluates to TRUE if:*  the changed field is "priority" 
* AND the old value is "P8"
* AND the diff between the creation date and the change date is less than 24 hours

* Then filter the spreadsheet to those rows where this column contains TRUE.

It sounds quite straight-forward to me.

Aron Gombas _Midori_ · Answer

There is the WAS operator, so you can know that the issue priority was "P8" some time. But, you cannot know if the initial value was "P8", I think.

(There is a WAS "P8" ON a given date, but you cannot use the "created" field as a given date, only a date literal, I think.)

Andrey Nikolaev_nl6hy1 · Answer

Ok thanks

Can we at least select all the bugs that were created in P8 priority?