Count the numbers of test cases

Hi,

Simple JQL query (not ZQL query) to get the count the number of test cases passed, failed, not-executed in zephyr squad. I want to get these numbers in Confluence.

How to retrieve the value of any field in zephyr test case using JQL. Is it possible today or not?

If not then any scripting that might help e.g. scritprunner or ??

Kindly help.

BR

Alok