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)
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Any other country that celebrates Midsummer holiday (this friday 22 June)?
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs