Querying the Current JIRA Database

[Adolfo Casari]

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,

[Adolfo Casari · Accepted solution]

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.

[Jeff Louwerse]

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();

[Adolfo Casari]

Thanks. Tried that but I still get null.