How to pass dynamic parameter in sql query

Archive
1

Hey guys,

I want to pass username dynamically in sql query but getting syntax error.
my code look like below

i need syntax to pass data in where clause.

CustomKeywords.'com.database.dbcontext.connectDB'()
def productQuery = 'select * from Users where UserName='data.internallyGetValue('username', 1)''
println(productQuery)
2

Hello,

treat your query as any other Java string - you can concat any value by + sign. Just use correct quotes and/or escape them correctly.

def productQuery = "select * from Users where UserName='" + data.internallyGetValue('username', 1) + "'"
2 Likes