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 vote

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

81 views 0 5
Read article

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