The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

SIL post function not working when I use standard variables

Steve Ryan
July 31, 2013

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!

4 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Steve Ryan
August 11, 2013

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!

0 votes
Florin Manaila
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 11, 2013

Hi Steve,

Is this still a problem for you? Can I help you further?

0 votes
Steve Ryan
August 1, 2013

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.

0 votes
Steve Ryan
August 1, 2013

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?

Comments for this post are closed

Community moderators have prevented the ability to post new answers.