How can I have a daily report that shows all the tests executed ,to be executed over a 5-day period?

[Soukaina IBALINE]

How can I have a daily report that shows all the tests executed and the remaining ones to be executed over a 5-day period, or by selecting a date range from date X to date Y?

[Danut M _StonikByte_]

Hi @Soukaina IBALINE,

How are the tests stored? Are they stored in Jira as issues/tickets? Or do you use a specific plugin for testing?

Danut. 

[Marsa Maroc]

Hey  Danut, 

Actually they are stored as tikcts , because when I write a test I write it as a ticket . 

But I do manage them in Xray plugin . Which ones are failed , passed , to do . 

Thanks

[Rudy Holtkamp]

You could create a JQL like this:

duedate >= startOfDay("-4d") AND duedate <= endOfDay() AND issuetype = "test" ORDER BY created DESC

You can replace 'duedate' with 'execution date'

[Marsa Maroc]

Hey Rudy,

I don't have those fields on my test case screen. I think I should add them and fill them automatically, so I can use them in the reporting.

In the test execution, we already have the 'Start At' field (which indicates when the test begins), but how can I add and populate the 'Execution Date' field?

Thanks.

[Lucas Modzelewski _Lumo_]

You can

• create a filter to match your criteria, then subscribe to it: https://support.atlassian.com/jira-software-cloud/docs/manage-filters/#Subscribe-to-a-filter
• use automation to create a ticket to review tickets, it can be a bit tricky at first, but with use of smart values it can be great: https://support.atlassian.com/automation/kb/creating-a-table-structure-in-jira-automation-rules/ 
  • I've used similar set up to review support tickets on weekly basis ;) 
• depending on used app check with app vendor - probably they have documented how to get reports from their tools ^^ 

[Marsa Maroc]

Hey Lukasz,

I think that's going to help, actually. But the problem I’m facing is that I’m using the Xray plugin, which makes it impossible to retrieve the execution status of a test — whether it’s been executed, or if it has failed. So, I can’t filter this information.

Do you have any idea ?

Thank you 

[Lucas Modzelewski _Lumo_]

looks like there are some possibilities: https://docs.getxray.app/display/XRAYCLOUD/Document+Generator+Template%3A+Test+Execution

But again you would need to check what exactly do you need (based on your data and set up) and ask Xray team for some support in helping you achieve it. 

---

Btw. Xray have their own academy, my whole QA team had to go through this as part of onboarding :)