Forum Discussion

_ivanovich_'s avatar
Frequent Contributor
5 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
    5 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.