It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get the Mapping between Workflow, Issue Type and project? Edited

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?

 

1 answer

1 accepted

0 votes
Answer accepted

Hi @Pereira Ariana 

 

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

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

Hi @Pereira Ariana 

 

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.

 

Regards,

Seba

@Sebastian Krzewiński  It doesn't work, this the error msg that I receive:

00936. 00000 - "missing expression"

What database do you have?

This query works in PSQL. You can easily change it if it is needed in other database.

@Sebastian Krzewiński It works! Thank you very much for your help!

 

Regads,

AP

@Pereira ArianaI'm glad that it work :)

If you don't might please accept my answer so other users can see that this query is working ;)

Finally, I realized that I need a query for "issue status" instead of "issue type".

I oponed another topic if you could help me plz.

Sure :)

 

Please paste link to new topic.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

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 ...

260 views 1 2
Join discussion

Community Events

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

Events near you