SIL post function not working when I use standard variables

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

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!

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?

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.

Hi Steve,

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

59 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you