Could you please help me with jira SQL query for finding all the Test Runs that got status updated from fail to pass , i have tried all the possible options and i'm getting some or the other error .
Request you to do the needful ( Currently i'm using below query )
project = "METM" AND issuetype = Test and TestRunStatus CHANGED FROM "FAIL" to "PASS"
Error message : -
- History searches do not support the 'TestRunStatus' field.
- The value 'FAIL' does not exist for the field 'TestRunStatus'.
- The value 'PASS' does not exist for the field 'TestRunStatus'.