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.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot