Change absolute path of groovy script used in a post function in the database


We are upgrading our version of JIRA from 5 to 6. I have a bunch of groovy scripts used in a bunch of post functions and they have an absolute path of /app/jira/installation/jelly/SCRIPTNAME.groovy. My app admin told me that this location will change during the upgrade. Is there somewhere in the database I can go and update this information using a sql statement instead of going into every workflow and every post function and manually changing the path location? FYI... I would have used relative paths but I didn't know our paths would ever change.



1 answer

1 accepted

I have code floating around that will create new drafts of every workflow and make some change, and then publish them, but I don't really recommend that approach unless you're pretty confident.

You could also update the descriptor column of the jiraworkflows table... and then restart. That might be ok if you have two or three workflows.

However I'd just tell your admin to create a symlink to the old location.

Thank you Jamie. I appriecate your help as always ;)!!!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,124 views 4 9
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