nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to display SQL results using groovy

Vineela Durbha

I am trying to display sql query results as below

sql.eachRow(select * from issue)
{row->
// log.error("loggggg" +row.values().toString());

}

But it is not displaying results. Am i doing something wrong?

can someone help on this

Accepted answers

Tuncay Senturk _Snapbytes_

Hello Vineela,

The name of the table should be jiraissue.

All comments

Tuncay Senturk _Snapbytes_

Hello Vineela,

The name of the table should be jiraissue.

Vineela Durbha

Even i tried with jiraissue .but no use

Tuncay Senturk _Snapbytes_

How is your whole code?

it should be "select * from jiraissue" with quotes.

Vineela Durbha

Yah it is "select * from jiraissue" with quotes

try {

sql = new Sql(conn);

def sqlQueryREC ="select * from jiraissue";

sql.eachRow(sqlQueryREC )

{row->

log.error("results")

}

Nothing is being printed from that log.error. Is my sql.eachRow method syntax correct?

If so how should i display all the rows and what is the syntax for it?

Tuncay Senturk _Snapbytes_

log.error("results") only logs results string if that's the one you see in logs.

However, if you do not see anything in the log file, just go to script console and try below code, you should see all issues in console, but jiraissue table may contain lots of issues so trying with another table should be wise (like issuestatus)

Try this one for jiraissue

import com.atlassian.jira.component.ComponentAccessor
import groovy.sql.Sql
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface

import java.sql.Connection
def delegator = (DelegatorInterface) ComponentAccessor.getComponent(DelegatorInterface)
String helperName = delegator.getGroupHelperName("default");
Connection conn = ConnectionFactory.getConnection(helperName);
Sql sql = new Sql(conn)
StringBuffer sb = new StringBuffer()
try {
  sql = new Sql(conn);
  sql.eachRow("select * from jiraissue") {
     log.warn("${it}")
     sb << "$it.id $it.summary"
  }
  return sb
} finally {
  sql.close()
}

Tuncay Senturk _Snapbytes_

And also please bear in mind that there is a loop here, so it might not have single result. In my code, I was concatenating all id values into stringbuilder.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

script-listener

groovy