Having issue with script running query

I am creating a scriptrunner script to query a db table and return a row. How do i access the result row which has only one column in it?

1 answer

0 votes

Use return to view it.

For eg:

def query_output = <syntax and query to be executed on db>

return query_output

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Here is my code

def sSql = "select Grouping from options where Segment = ${sSegment} and Service = ${sService}"
row = sql.firstRow(sSql) { }

Not sure if i got the syntax correct

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.