Get project key of a linked issue in JQL

[Gergana.Damyanova]

Hi, I'm doing some automation that aims to update an issue's field after the linked issue is closed. The field I want to update should have the value of the linked issue's project. I try to define a variable in the automation which should extract the project key, but for some reason this doesn't work.

For now I'm experimenting with getting some value and assigning it as a label to see if the value will be correct, and assign value to the variable to be {{project}}, but it doesn't work. Is this the correct way to extract the project's key or it's something else?

[Andy Heinzer]

Your dbconfig.xml looks ok to me.  I don't yet have an explanation as to why you might not be able to connect with those settings, perhaps there is something wrong with the URL value, or the username/password in question.

I would recommend using the sample dbconfig shown at the bottom of this document: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-oracle-938846856.html

What sort of error do you see?  Perhaps you can look in the $JIRAHOME/log/atlassian-jira.log file when Jira tries to start up and see what errors might get generated there to help us understand why this might not work as expected.

Additionally, you can try to use the Jira config tool in order to test a connection to your database.  This utility can both set and test your dbconfig.xml connection settings without actually trying to start Jira itself.