I need to know how many defects ( issues of type defect) does each Dev task have ? IS this possible? Currently, I am getting all links ( action items, UT defects,etc.) in comma seprated formatted.

6 answers

This could be calculated with Script field provided by Script Runner plugin. Can you use it?

0 vote

You'll also need to describe how you are storing the data in JIRA

Kshama, If your intention is NOT to automate the process for now, you can filter the issue types you want (Dev Tasks and Defects in this case) including the column that indicates the links between the parent issue with children issues, export the data to Excel and do a simple pivot to get your results. If automation is required, then I would suggest to check on Zephyr Enterprise.

@Vasiliy - Script Runner is paid right ? is this possible in AM Utils?

Nic - What information you need abt data model ? I can ask PMO for information

1) Yes, it is payd.

2) I am not good about AM Utils.

For free solution it is possible to try using SQL Query.


0 vote

As Guhan suggested, you could do this using Excel pivot tables generated by the Better Excel Plugin.

Guhan - The problem is in Excel I cannot distinguish between 'Defect', 'Action Item', 'DCR',etc. Iam  intrested only in defect for quality metrics

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published Monday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

470 views 7 8
Read article

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