Hello,
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
Thanks Tom,
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.
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.