How to get total passed and total failed testcases count using filters in Jira cloud ?

[Suma Patil]

Hi,

Unable to find filter to get passed or failed testcases in Jira cloud ? 

[Alex Koxaras _Relational_]

Hi @Suma Patil and welcome to the community,

Which app do you use for test management? If you are using zephyr, zephyr stores the test executions outside of Jira and you can only use their reports and gadgets to get the pass/fail executions.

[Suma Patil]

We are using X-Ray. I want to use the filter in confluence page to show total passed testcases count in table.

[Alex Koxaras _Relational_]

Take a look at this https://docs.getxray.app/display/XRAY/Enhanced+querying+with+JQL

[Suma Patil]

Hi @Alex Koxaras _Relational_ , These JQL queries supported only for JIRA Server but not for Jira Cloud. 

[Alex Koxaras _Relational_]

Mea culpa! Didn't actually see this.

It seems that in cloud these JQL indeed do not work. So there is actually one solution, as Zephyr: https://docs.getxray.app/display/XRAYCLOUD/Test+Executions+List+Report