Zephyr latest test execution

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.

2 answers

1 accepted

This widget could not be displayed.

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

This widget could not be displayed.

Hi Stanislav!

Test issues and their issue type 'Test' will be imported to eazyBI, but currently Zephyr specific fields like Test status or other Test execution details by default are not imported to eazyBI. We are concidering possibilities to add import of Test specific fields to eazyBI.

For now I can suggest you to import additional properties to the test issues, like latest test execution result and date, as SQL select from JIRA database.

Please let me know if you need assistance with creating this SQL select or column mapping for this additional data import.

Kind regards,
Lauma
support@eazybi.com

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

139 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you