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,
issc.name AS issuetypescreen
proj.id = na.source_node_id
na.sink_node_id = issc.id
AND sink_node_entity = 'IssueTypeScreenScheme';
Link to Jira SQl examples: Example SQL queries for JIRA
Link to Get Issue Types for project example: https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-GetIssueTypesforproject
SELECT IT.id, IT.pname FROM configurationcontext CC LEFT OUTER JOIN optionconfiguration OC ON OC.fieldconfig = CC.fieldconfigscheme LEFT OUTER JOIN issuetype IT ON IT.id = OC.optionid WHERE CC.project = 10000
10000 is ID of the project
thank you so much.
but i have been reading the documentation and i read this:
Notes about working with the JIRA database:
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?
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)
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot