JIRA custom field query: To get all the custome field associated with an Issue.

Sumit akare August 13, 2013

We have following custom field:

Severity ( having 4 different values ).

We want to genrate a report for a perticular auther (in changegroup ), how many issues he/she

has marked status ( NEWSTRING) as "Fix Accepeted" for a given duration of time.

Please help with sql query.

Thanks in advance.

Thanks,

Sumit

3 answers

1 accepted

0 votes
Answer accepted
Sumit akare August 25, 2013

I have created a query on below tables to get the required data.

jiraissue,issuestatus,customfieldvalue,changegroup

0 votes
Sumit akare August 20, 2013

I have created a query on below tables to get the required data.

jiraissue,issuestatus,customfieldvalue,changegroup

0 votes
Timothy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 13, 2013

A changegroup is tied to a username and a changegroup has many changeitems. A changeitem is tied to a custom field and uses the oldvalue/oldstring and newvalue/newstring. Start from there.

Suggest an answer

Log in or Sign up to answer