Guess who's back! Okay so I have this working during a transition (the two CustVars are fields on the transition screen):
string strDBRequestDesc = "Variable 1: " + #{CustVar1} + "\n Variable 2:" + #{CustVar2};
string strIssueSum = 'test Issue summary';
string strJiraID = 'JIRA-123';
string strUser = 'me';
string [] results = sql("CustDBConnection", "EXEC dbo.SampleStoredProcedure @CommType = 'U',@CommFrom = 'Other',@CommDesc = '" + strDBRequestDesc + "',@CommSubject = '" + strIssueSum + "',@CommJiraID = '" + strJiraID + "',@user = '" + strUser + "',@SendMail = 1");
If replace the variable assignment with standard variables it doesn't work:
string strIssueSum = description;
string strJiraID = id;
string strUser = assignee;
I also tried putting the standard variables inside #{} and it didn't work. The editor tells me that my syntax is okay. I have a guess that while the transition screen is shown, there is no issue context, but there should be right? Thanks again for the help!
Hey I tried to come back and post the answer but this site was down when I tried. I was using "id" instead of "key" which I believe was my problem. JJUPIN also keeps disabling itself (it's supposed to be running under a demo license but the warden just keeps disabling it) so that could've been an issue as well. Thanks for checking!
Hi Steve,
Is this still a problem for you? Can I help you further?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well I used this to enable logging:
http://confluence.kepler-rominfo.com/display/JJUP20/Configure+JIRA+Logging
I set it to WARN, which produced no messages, so now I'm going to try print() to see the values during the transition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If no one knows what could be wrong, could someone tell me how to enable/create some detailed logs so that I can figure out where the error is occurring?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.