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
I have created a query on below tables to get the required data.
jiraissue,issuestatus,customfieldvalue,changegroup
I have created a query on below tables to get the required data.
jiraissue,issuestatus,customfieldvalue,changegroup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.