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.
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
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.
Please let me know if you need assistance with creating this SQL select or column mapping for this additional data import.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot