Trying to find out in which Issue type scheme which issue type is used

Question

I will like to know which issue type scheme is using which issue type. I therefore tried the following but the result is incomplete as there are far more issue type scheme within our system. What am I missing?

select issuetype.ID, issuetype.pname, issuetypescreenscheme.NAME, issuetypescreenscheme.ID, issuetypescreenschemeentity.ISSUETYPE,
issuetypescreenschemeentity.SCHEME
from issuetype, issuetypescreenscheme, issuetypescreenschemeentity
where issuetype.ID = issuetypescreenschemeentity.ISSUETYPE
and issuetypescreenscheme.ID = issuetypescreenschemeentity.SCHEME

Any help appreciated,

Thanks

Tabe Nyenty · Answer

You´re missing something this can´t be done from the Admin console if so I´m not really sure on how to proceed here.

Tinker Fadoua · Answer

Why don't you do it from the Admin Console? Instead of the code above? May be I am missing something which I apologize

Tabe Nyenty · Answer

Hi Fadoua,

Yes i have access to JIRA as an ADMIN and I´m also a server user