Using groovy how do i pass parameters to the sql statement?

Robert Walton September 1, 2020

I am writing a groovy script to read a database table and am having trouble with the sql statement. I need to pass it two parameters but it seems i can not get the syntax correct.

ex: def sSql = "select field from table where Segment = $sSegment and Service = $sService"

Would someone be able to show me the correct syntax to pass a parameter to the sql statement?

1 answer

0 votes
Didem K October 19, 2021

import groovy.sql.Sql

 

def segment

def service

def resuslt = sql.rows("select field from table  t where t.segment=? and t.service=?" ,segment, service);

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events