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)
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs