Forum Discussion

kailashlatad's avatar
kailashlatad
Occasional Contributor
5 years ago

How to pass value from properties in query parameter ?

Hi All,   I am trying to pass value from propeerties in query parameter using ${Properties#Type} in get request, but when i am giving ${Properties#Type} the same content is passing while sending re...
  • shishija's avatar
    5 years ago

    If you are asking about passing a property value to a Query in JDBC Request then your approach is correct. Its just that if query parameter type is string then use single quotes otherwise use property as is. Below is simple example:

     

    SELECT *
    FROM EMPLOYEE 
    WHERE LAST_NAME = '${EMP_DTL#LAST_NM}' AND
    EPMPLOYEE_ID = ${EMP_DTL#EMPID)

     

    In this example EMP_DTL is Properties step where LAST_NM and EMP_ID are properties stored in. Hope this help resolving your issue. Accept this as solution if this really helps or provide more details on what you are trying to achieve with details explanation of your tests.

     

    Thanks