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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...
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