Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Add a watcher from specific group

Alex Baker
August 15, 2022

Hi, Alex is here.

Is it possible to add a watcher to an issue automatically, from a specific group, like I can assign an issue to a group of users.

I only know how to add the exact user, but I need to add group with users.

1 answer

0 votes
Kelsey Collins
February 24, 2016

In a workflow post  function, we need the ability to run an SQL execute statement to execute a stored procedure on a database other than the JIRA DB. 

 

Example:  on the transition of a UA – New User item from ‘Open’ to ‘Account Creation’ we need a post function that will execute a script similar to this EXEC MyServer.MyDB.dbo.MyStoredProc @Param1, @Param2

Christian Jaya
January 12, 2018

hello I have the same problem,

i need to run an oracle store procedure from JIRA, but i dont understand your post, please, can you tell me where exactly i must put the sentece that you describe above, and please explain me all the parameters that you use

XEC MyServer.MyDB.dbo.MyStoredProc @Param1, @Param2

even de reserved words

thank you so much

karthik_kande
February 5, 2019

We do have the same requirement, is there any documented approach or process as how a Jira application(anything  core app, sd, software) talks to database stored procedures of external database server. 

We have lot many procedures to be called upon and take results and make the appropriate changes to the Jira workflow process. 

we do have script runner from adaptivist.  we do not want to split the code base into different post functions, some generic way?? 

any documented way  ? really appreciate it. 

Thanks advance..

Suggest an answer

Log in or Sign up to answer