I am quite new to groovy scripting. I have a following code
def results
def dbConn ()
{
//all db connection parameters
results = sql.rows("SELECT * FROM jira.APP_USER au WHERE LOWER_USER_NAME = 'abc'")
}
def sendEmail
{
//email sending parameters
email.setBody(results)
}
I am able to access the results variable inside the both the methods, how do i declare a variable globally so that i can access it through out the code.
Exception :
ERROR [common.UserScriptEndpoint]: Script console script failed: groovy.lang.MissingPropertyException: No such property: results for class: Script754 at Script754.sendEmail(Script754.groovy:121) at Script754$_run_closure3.doCall(Script754.groovy:102) at Script754.run(Script754.groovy:62)
Hi @Nagappan Murugappan it will be quite simplified but it should work:
def getResults () {
//all db connection parameters
return sql.rows("SELECT * FROM jira.APP_USER au WHERE LOWER_USER_NAME = 'abc'")
}
def sendEmail() {
//email sending parameters
def results = getResults()
email.setBody(results)
}
sendEmail()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you are welcome :)
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.