Hello everybody,
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?
Hi @TAGNAOUTI Khaoula
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.
Similar topic: https://community.atlassian.com/t5/Jira-questions/the-relations-between-project-and-workflows-in-the-database/qaq-p/11249
Regards,
Seba
Hi @Sebastian Krzewiński
Thank you for your return.
This query shows the "workflow scheme" information not the "workflow" information.
However, it doesn't show the Issuetype information.
Regads,
AP
What query?
The query indicated in the link above:
SELECT *
FROM PROJECT, NODEASSOCIATION, WORKFLOWSCHEME
WHERE PROJECT.ID = NODEASSOCIATION.SOURCE_NODE_ID
AND NODEASSOCIATION.SINK_NODE_ID = WORKFLOWSCHEME.ID
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.schemewhere 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.
It looks like you're new here. Sign in or register to get started.
