nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

updating workflow jira directly in databsae

doumghordi el mustapha

Hello Atlassian community ,

please help me ?

in order to perform an optimized workflow migration without ID change, name créator ... (already done this workflow in test environment), I want to update it directly on the database (jiraworflow) but it does not work ??

is there a JIRA cache for workflow? otherwise you have ideas. I am really stuck on this problem. help me

best regrards

Accepted answers

All comments

Danyal Iqbal

This is a Bad idea. You will break the db 9 times out of 10 times. It won't work.

Try the saner route. Export/import the workflows through the Ui and let jira handle the internals.

Steve Thornhill_57zt4f

It is not recommended to perform these type of updates directly on the database.

Have you considered looking at additional tools such as Project Configurator which would allow you to push the changes from the test environment into production?

https://marketplace.atlassian.com/plugins/com.awnaba.projectconfigurator.projectconfigurator/server/overview

doumghordi el mustapha

there are a lot of project like 200 projects so for that's reason a try to choose this solution

Nic Brough -Adaptavist-

Do not update the Jira database. You are almost certainly going to get it wrong, and break it.

If you absolutely must do it with SQL, then you must stop Jira, back up the database, prove you can restore a Jira system from the backup you have taken, then run your SQL, restart it and re-index before letting the users in.

If you are not an expert on the internals of Jira, then consider this question: Can you tell me all of the 6 tables (minimum - there's usually more depending on the change) you need to update and how with your SQL if you change a workflow? If you can not do that, then you should not touch the database.

doumghordi el mustapha

thank you,

but i have a lot of probleme with this method :

1° if i do that i risk to have dublicated customerfield and screen

2° my import xml don't work because saxexcpetion i have to put modify 4 Go entity file ...

3° i need to keep the same information in production like last modification , ...

Danyal Iqbal

These are minor issues.

1° and 2° are insignificant. 3° is not possible.

I suspect that you are talking about the xml for the complete backup, which is huge? You can export only the workflow for distribution as well.

doumghordi el mustapha

thank you Nic Brough , so do have any solution do update workflow in production with minimum downtime ? (import/ export xml generate a lot of problem like dublicate screen , customufiel, ) , there are no api rest ... . i 'm really stuck.

i read the architecture of jira and dependency between table so i see just one table for active workflow.

best regard

Nic Brough -Adaptavist-

Ok, so you really do not understand the database well enough to even look at the SQL (you're not alone, it's not a simple database)

If you need to update the workflow, then edit it in the UI. There is a draft mode that lets you change most of it.

doumghordi el mustapha

Merci

The problem here is, That all the conditions, validators and post-functions will not be migrated with the workflow. So i have to manually add all the conditions, validators and post-functions.... .

And there are a lot of modification (remplacement home made plugin for standard plugin like JSU or SCRIPTRUNNER).