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
It looks like you're new here. Sign in or register to get started.
