Zephyr latest test execution

Stanislav Polyakov

Hello!

I need to get latest test execution to watch status of whole test.

For example: I have some testers which has his own test Cycle. In each cycle tests could repeat between cycles. (Tester 1 in his cycle has tested Test 1 and Tester 2 in his cycle has tested Test 1)

So, here is the question, how can I get selection with latest tests execution? Is it possible to get analog of SQL GROUP BY in JQL which will give me uniqie tests and their latest executions?

Or is it possible to use eazyBI addon to solve this problem?

Current solution which I use is to get full export of all executions into excel, group by 'test summary' and order by 'executed on', but with 400+ tests it is very difficult.

Mehmet Kazgan_qriny9

Hi Stanislav,

I don't think you can do Group by attribute in JQL or ZQL as they are not generic querly languages like SQL.

Yes, eazyBI should solve that problem, you definitely use the trial version to give it a try.

What I do is I have COnfluence with SQL plugin and I query directly to JIRA DB with SQL and display the reports as I want in Confluence dynamically.

If you are not worried about displaying this to users dynamically, you can simply use SQL Express and query to your JIRA DB.

Here is an example for SQL query about the test cases:

Test Cases last executed On with a column of failed tests:

SELECT c.NAME, c.DESCRIPTION, MAX(DATEADD(MILLISECOND, cast(AO_7DEABF_SCHEDULE.EXECUTED_ON as bigint) % 1000, DATEADD(SECOND, cast(AO_7DEABF_SCHEDULE.EXECUTED_ON as bigint) / 1000, '19700101'))) as [Last Executed On], sr.Total as [Failed Tests]
FROM AO_7DEABF_SCHEDULE,(select AO_7DEABF_CYCLE.NAME,COUNT(AO_7DEABF_SCHEDULE.ID) as [Total] from AO_7DEABF_CYCLE,AO_7DEABF_SCHEDULE WHERE
AO_7DEABF_SCHEDULE.CYCLE_ID = AO_7DEABF_CYCLE.ID
AND AO_7DEABF_SCHEDULE.STATUS ='2'
AND AO_7DEABF_CYCLE.PROJECT_ID = 'XXXXX'
GROUP BY AO_7DEABF_CYCLE.NAME) sr
INNER JOIN AO_7DEABF_CYCLE c ON c.NAME = sr.NAME
WHERE c.PROJECT_ID = 'XXXXX'
GROUP BY c.NAME,c.DESCRIPTION,sr.Total