Would like to pass a value to a stored procedure using Groovy

[Josh Simnitt]

I'm trying to run a stored procedure from within Jira, either as some type of button or a form that the user can select choices from which will be passed to a Groovy script.  The Groovy script contains a stored procedure that would need to take these values as arguments. 

Is there a way to do this within the  Jira UI by creating a script fragment or something similar?  I've tried creating a web item but haven't been able to figure out how I could pass an argument to the script.  If anyone has some pointers or suggestions I would like to know. 

I've ran the script itself with values in it within ScriptRunner console, so I know the script works with the example arguments.  

[Hana Kučerová · Accepted solution]

Hi @Josh Simnitt ,

it reminds me of Dynamic Forms, but probably it won't be enough...

[Josh Simnitt]

Thank you, I'll look into that.

[Josh Simnitt]

It worked for me