Forum Discussion

_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
6 years ago

How to use property value in sq with groovy?

Hi, i have a request with a response. i transfered a value from the response using Property Transfer into Projetc Properties. Now i want to use the value from the project property in my sql req...
  • _ivanovich_'s avatar
    _ivanovich_
    6 years ago

    I found it, it should be:

     

    def per_id = context.expand('${#Project#Reqid-received}'')

    Then us it in sql like:

    sql.eachRow("select * from Person where PER_ID = "+re_id+" ")

     

    It works. 

_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
6 years ago

I found it, it should be:

 

def per_id = context.expand('${#Project#Reqid-received}'')

Then us it in sql like:

sql.eachRow("select * from Person where PER_ID = "+re_id+" ")

 

It works.