There is any database table in JIRA has the mapping information between workflow, Issue Type and project?
I checked the database but I didn't find a table with association.
Could you please help me for this issue?
Mapping between project and workflow scheme (and other schemes) you can find in nodeassociation table. Then (knowing workflow scheme id used in project) you can find workflows assigned to issue types in this specific workflow scheme in workflowschemeentity table.
Query from article was not good.
Try this one:
select n.source_node_id, w.scheme, n.sink_node_id, w.workflow, w.issuetype from workflowschemeentity w
join nodeassociation n on n.sink_node_id=w.scheme
where n.source_node_id=<project_id> and n.sink_node_entity like 'WorkflowScheme'
Now you need to know only project id and put in query.
Please let me know if it works for you.
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events