I am running the query quoted here:
Querying the Current JIRA Database
in Script Console, but I get: null
Scriptrunner version is 3.1.4
JIRA 6.4.9
Thanks in advance,
Looks that the Script Console only show results if you use return in the code, so instead of:
log.debug sb.toString()
I use
return sb.toString()
to show the results of the query.
Personally I use the built in method to query JIRA's internal tables . They replacing your connection declaration with this one. I cant say for sure it will work as it as I use pure java implementation.
import com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory; Connection conn = new DefaultOfBizConnectionFactory().getConnection();
conn
Thanks. Tried that but I still get null.
It looks like you're new here. Sign in or register to get started.