JIRA Queries

[Kshama Pawar]

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.

[Aron Gombas _Midori_]

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

[Kshama Pawar]

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

[Vasiliy Zverev]

1) Yes, it is payd.

2) I am not good about AM Utils.

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

[Kshama Pawar]

@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

[Deleted user]

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.

[Nic Brough -Adaptavist-]

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

[Vasiliy Zverev]

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