Xray: : Filter to extract Retest failed tests and test status changes

Question

Good day

I need help with a couple of things

1) Query for extracting the List of Test cases which were marked as Failed and then moved to Passed status.
We have tried all the possible options from our end and getting an error message when we are using the below query

Project = "XX" AND issuetype = Test and TestRunStatus CHANGED FROM "FAIL" to "PASS"

Is it because the ' CHANGED ' Operator is not recording the history of test run status (Todo > Fail > Pass; Todo > Blocked > Fail?

2) This probably the same question as question 1, but Is there a way to get history information based on TestRunStauses Changes as per the JQL (not working) below?

project = "xx" and issuetype = test and TestRunStatus = pass and TestRunStatus changed before -2

3) Is it possible to run a JQL  to extract tests based on "Started On", "Finished On" in test runs for a specific duration (similar to XRAY - Test Runs report)?

Example JQL that is not working due to "TestRunStarted" not existing in JQL

project = "xx" and issuetype = test and TestRunStatus in ("Fail","Aborted") and TestRunStarted !=Empty

Regards,

Juan

unknown · Answer

Hi Ela,

Unfortunately, no it does not work in cloud.

Unless there is an upgrade happening for this, but none that I have seen so far.

Thanks,

Anshika

ela lir · Answer

Hi Anshika,

We're not on cloud yet.

So there is no way to achieve the same functionality on cloud?

Kind regards

Ela

unknown · Answer

Hi Ela,

This used to work for me when we were using JIRA on server but ever since we have moved to cloud this does not work anymore.

Unable to find JQL function 'testPlanTestExecutions(<testexecutionid)'

Would you be able to confirm if you are using cloud?

Thanks,

Anshika