Tables in JIRA DB containing the project id and schemes associated with it

mohit mathur

I want to create a list containing projects, issue types associated with that projects and schemes associated with that projects. I was looking for a table in JIRA DB which contains a relation between projects and schemes associated with it. 

Is there any table in JIRA DB containing projects id and schemes associated with it ?

Chander Inguva

Hi mohit,

• There is no direct table which has project ids and schemes associated with it.                 

• You can create a list containing projects and their issue types 

  select * from jiraissue where PROJECT=<Project_ID> AND issuetype=<Issuetype ID>;

• To get the Project ID and Issuetype ID you have to look into project and issuetype tables respectively.

• This gives all the issues of that particular Project and corresponding issue type associated with the Project
  
  

Regards

Chander Inguva