Where can I find in the database the Issue types that belong to each Issue Type Scheme?

[Lara López García]

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

[Deleted user]

You might check here:

https://developer.atlassian.com/jiradev/jira-platform/jira-architecture/database-schema

[Lara López García]

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.