How to extract id value from sql query using groovy

Vineela Durbha

I am trying to run groovy script to extract ID from jira db

Connection conn = ConnectionFactory.getConnection(helperName);
log.debug("connection succees")

Sql sql = new Sql(conn)
def row;
StringBuffer sb = new StringBuffer()

try {
sql.eachRow("""select ji.id as 'ID' from jiraissue ji
left join project p with(nolock)
on ji.project = p.id
where p.pkey='SWRM' and ji.summary='19.10'""") {
//log.warn("${it}")
sb << "${it}"

}
sb.toString()
log.debug("sb value " +sb)
return sb
} finally {
sql.close()
}

 

sb is returning [ID:873319], but i just want to extract 873319 so that I can pass it to another field.

Payne

You could use the substring function to remove the first 4 and last characters.

sb.substring(4,sb.length()-1)