Search code examples
testingjirajira-xray

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

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

Solution

  • 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). saved filter for obtaining the Test Executions on a project

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

    Then you will be able to see the list of Tests executed today, using the previous configuration. Test Runs List gadget example

    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).

    Test Execution issue with 2 tests executed on a given day

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

    JQL search for tests executed on a given day

    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.