Forum Discussion

kailashlatad's avatar
kailashlatad
Occasional Contributor
5 years ago
Solved

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
    shishija
    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

shishija's avatar
shishija
Occasional Contributor
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