How to check how many test cases run on specific day in Jira

Question

I use jira for my test management and almost 30+ tester work in the project. I would like to know is there any method I can filter out the test cases executed on a specific day [ say today ]. It can be any status passed / failed etc. In my test plan there are many test executions run in parallel. I tried to use the test run report feature from Xray but seems I cannot filter only finish day, which leads to wrong results it pull the test cases from previous days too. If I give start date and finish date same, its not fetching the data executed today. Please help

Answer 1

You have several ways to achieved this. The first one is to use the Test Runs List gadget in a Jira dashboard. Start by creating a saved filter for the Test Executions that you wish to process (e.g., all the Test Executions on project CALC).

Then go to a Jira dashboard and add the "Test Runs List" gadget, and enable date range filtering.

Then you will be able to see the list of Tests executed today, using the previous configuration.

In Xray Datacenter you can also take advantage of JQL functions to perform some queries. In this case, the testExecutionTests JQL function; it accepts either a saved filter id or a Test Execution issue key.

Let's say we want to know the list of tests executed on 2024-01-15, in the scope of some Test Execution "CALC-390":

issuetype = 'Test' and issue in testExecutionTests('CALC-390', '', '', 'false', '', '', '', '>=2024-01-15', '<2024-01-16')

As an example, consider the following Test Execution with 2 tests executed today (2024-01-15).

This would be the JQL we could use on the issue search page, returning the 2 tests.

Lastly, you could also use a BI like tool, such as eazyBI that can process Xray data. However, this requires an additional paid plugin to achieve it.