database - issue type of a project


how can i know the issue types that belong to a project? if i use the table nodeassociation i know the issue type screen of project, but not issue types. where is the table that relates "issuetype" whith "issuetypescreenscheme"?


proj.pname AS project, AS issuetypescreen


project proj


nodeassociation na

ON = na.source_node_id


issuetypescreenscheme issc


na.sink_node_id =

AND sink_node_entity = 'IssueTypeScreenScheme';


3 answers

1 accepted

1 vote
Accepted answer

Link to Jira SQl examples: Example SQL queries for JIRA

Link to Get Issue Types for project example:

SELECT, IT.pname
FROM configurationcontext               CC
LEFT OUTER JOIN optionconfiguration     OC ON OC.fieldconfig = CC.fieldconfigscheme
LEFT OUTER JOIN issuetype               IT ON = OC.optionid
WHERE CC.project = 10000

10000 is ID of the project

still works today but you might want to add  this to the where clause  

 and CC.customfield = 'issuetype'

I hope you don't mind but I updated to the tags to be JIRA instead of Stash which is what I assume you meant.

thank you so much.

but i have been reading the documentation and i read this:

Notes about working with the JIRA database:

(warning) Please Note: Direct database queries are not recommended in JIRA. Instead, we recommend adding or modifying data via JIRA's REST APIs, JIRA RPC Services (deprecated) or Jelly Tags.

But, my my goal is only acess to information, not modify. It is recomended use the res api (for example) for this?

With the rest api can i acess an issue types of a project?

best regards

ana mendes

Ana, please do not worry about this note from Atlassian. All API are very poor, and Atlassian changes focus often from one API to another. For example, they drop Jelly and try to imporve REST but it is still not very functional. Use database, to read or to write (but test everyting first in a non-production instance)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,018 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you