the relations between project and workflows in the database

I did not how find to extract the information in the database of the relations between project and workflows

1 answer

0 votes

A project (project) has a workflow scheme (workflowscheme) linked by entries in a linkage table (nodeassociation  - read it for ProjectScheme and WorkflowScheme).  The workflow scheme then tells you which workflow (workflowschemeentity) an issue type is set to use

You can see why my next piece of advise is "do not use the database directly, use the API"

Ok in the table nodeassociation  i have SOURCE_NODE_ENTITY   /    SINK_NODE_ENTITY / ASSOCIATION_TYPE and I suppose is the relation with workflowschemeentity but I am not interstand why is in relation.

 

They're linked by the ids for each table.

Could you explain why you are trying to do this the hard way?  What is the goal of this exercise?

The idea is to be able to make extractions of the parameter at the moment T before the implementation of new project and make me an idea on the existing in an Excel file for example.
I have 120 projects in the base JIRA current and am going to develop the projects

I don't see what the scheme data would help you with there.  It's not going to help you set up projects and it's not a backup.

I have more than 200 projects than I am spirit to standardize to make homogeneous the types of requests as much as possible some compared with the others and reduce the number of workflows and screens.

The interface in JIRA gives me only project by project all the parameters.

And I did not find other means to have the overview that to pass by an extraction of the database.

Pour finir j'ai trouvé ce que je cherche:

SELECT *

FROM PROJECT, NODEASSOCIATION, WORKFLOWSCHEME

WHERE PROJECT.ID = NODEASSOCIATION.SOURCE_NODE_ID

AND NODEASSOCIATION.SINK_NODE_ID = WORKFLOWSCHEME.ID

AND PROJECT.ID = '11630'

 

Ok, that's understandable and correct, but it tells you nothing more than the UI does.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,898 views 12 18
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot