JQL

[Manu Mishra]

I am trying to use "CHANGED" operator in JQL syntax. Basically i am trying to find the field value has been changed or not. Below is my syntax;

project = CS and issuetype = General and "Result" CHANGED FROM "Passed" TO "Failed"

While running i am getting below error:

• History searches do not support the 'Result' field.
• The value 'Failed' does not exist for the field 'Result'.
• The value 'Passed' does not exist for the field 'Result'.

 However i see the field and their values as well in issue history and they have been changed by the people. How can I get this result through JQL as i need to create a report. OR if there is any other way around (e.g.. using Script Runner) please let me know.

[Ignacio Pulgar]

Only a few fields support the CHANGED operator, as stated here:

This operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html