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
Hi Tabe,
Do you have access to JIRA as a JIRA ADMIN?
Are you s jira cloud or server user?
Hi Fadoua,
Yes i have access to JIRA as an ADMIN and I´m also a server user
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why don't you do it from the Admin Console? Instead of the code above? May be I am missing something which I apologize
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.