Hi,
The below query worked for me. Give a try.
SELECT DISTINCT P.pname, P.pkey, P.lead AS project
FROM project as P
INNER JOIN jiraissue as J on J.PROJECT = P.ID
INNER JOIN issuetype as I on I.ID = J.issuetype
WHERE J.issuetype= 10300
Thanks,
Ipsita Dash
@Ron Jacob, you can find this information on the issue type scheme administration screen.
Here is a SQL query that will return the list of project for all issue types:
select IT.id, IT.pname, PROJ.name
from configurationcontext CC
join optionconfiguration OC on OC.fieldconfig = CC.fieldconfigscheme
join issuetype IT on IT.id = OC.optionid
join project PROJ on PROJ.id = CC.project
order by IT.pname;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Ron Jacob, if my answer addressed your question, would you please 'Accept' it?
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.