Where can I find in the database the Issue types that belong to each Issue Type Scheme?
I have found lots of answers to this question using the screen schema or the field configuration scheme, but I cannot use the because we have some projects that share the workflow/screen/fields schema but only differ in Issue type schema.
Thanks in advance
I have alredy checked there but I cannot find a good way to obtain the issues.
I have a workaround with checking the issues of projects similiars of the ones I want the issues like:
SELECT IT.id, IT.pname
FROM configurationcontext CC
LEFT OUTER JOIN optionconfiguration OC ON OC.fieldconfig = CC.fieldconfigscheme
LEFT OUTER JOIN issuetype IT ON IT.id = OC.optionid
WHERE CC.project = 12700
But it is not really what I am looking for. I have queries to obtain the fields per field schema o screen schema like
select a.pname, b.scheme from issuetype a
left join issuetypescreenschemeentity b on a.id = b.issuetype
where scheme in (11200);
But, as I said before, I have projects that share the field schema but differ in the issue type schema so they are not perfect.
Any help would be greatly appreciated.
I'm John Allspaw, co-founder of Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...
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