Forum Discussion

AnandKiran's avatar
AnandKiran
Frequent Contributor
16 years ago

How to collect a value retrieved in a database in a property

Hi friends,
               Here there is a scenario where i want to collect the value retrieved from a Datasource step and then i want to pass the same value to another datasource  step

Step 1: Data source step with query
             Select * from CONT where CONT_NBR = '6639010'

     I have created two properties in this step CONT_NBR & CONT_ID

Step 2 :  Property transfer step which is used to transfer the property CONT_ID
Step 3: Properties Step to store the value CONT_ID

Step 4: Propery transfer step to transfer the CONT_ID

Step 5: Datasource step to check one more query
            Select * from CONT_ENTM where CONT_ID = '{{CONT_ID}}'

But step 4 ans step 5 has failed it is not able to transfer the property value collected  in step 3 to step 4.

can you help me in this issue .

Thanks
With Regards
Anand Kiran G

2 Replies

  • omatzura's avatar
    omatzura
    Super Contributor
    Hi!

    please try disabling the second property-transfer step (step 4) and changing the SQL in your second DataSource to

    Select * from CONT_ENTM where CONT_ID = '${#}'

    ie something like

    Select * from CONT_ENTM where CONT_ID = '${Properties#CONT_ID}'

    Does that work ok?

    regards!

    /Ole
    eviware.com
  • AnandKiran's avatar
    AnandKiran
    Frequent Contributor
    Hi Ole,
                Your suggestion worked perfectly . Thanks a lot

    Cheers!!!