Xray JQL question, how do query for test case execution history

[Itsik Versano]

Hi, 
I want to create a list (JQL) per project or component of test case and how many times it failed from the total number it was executed. 

Any idea how to do so?

[Itsik Versano]

Hi @Laurie Sciutti 
This will get me current result, any idea how to get history?

BR
Itsik

[Laurie Sciutti]

Hello @Itsik Versano ~ try the following (with a custom filter searching for all Tests that you want to include):

issue in testTestExecutions('your custom filter', 'PASS|FAIL')

If you want to include additional test run statuses (i.e. ABORTED) just include that using the "|" (pipe) separator ('PASS|FAIL|ABORTED').  Reference:  https://docs.getxray.app/display/XRAY/Enhanced+querying+with+JQL