Our team has migrated from Quality Center to Jira tool. We have installed Jira plugin Zephyr for execution.
But issue is we need to macro in excel where we can generate report automatically for bugs and executions. We have the jira queries in UI. From database putting sql queries is getting difficult as database is not well organized in Jira.
Can anybody tell me how can we automate excel having jira queries results like (total reopened bugs, critical bugs, total execution count of daily)?
Haha, when you're looking for JIRA Excel automation, you should try the Excel Automation Plugin for JIRA.
It basically automates the generation and emailing, saving or attaching Excel reports using highly customizable templates rendered to a final XLSX file by the Better Excel Plugin. Based on your description, this sounds as it is exactly what you need.
Please take a look at eazyBI report creation add-on for JIRA. With eazyBI you can create custom reports based on JIRA data. eazyBI also supports Zephyr specific custom fields, see more details here https://docs.eazybi.com/display/EAZYBIJIRA/Zephyr+Test+Management.
Let me know if you have any questions regarding eazyBI!
Lauma / firstname.lastname@example.org
The JIRA database is not "not well organised", it's designed to store the application data efficiently. It's absolutely not intended for reporting.
Atlassian can't know what every different client might want from a spreadsheet, so the software can only really give you the data in a usable formula.
If you want to use functions on it, you have two options
There is a third option - report inside JIRA instead - it can answer all the questions you've posed in your question (but I suspect you have more)
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