Dynamically pass value dynamically in trestquest with tmysqlinput

[Anonymous]

i have facing problem in to get  data from database using trestrequest , txmlmap and tmysqlinput. my question is i m passing value in url like {doctorName} and that value which i have passing in url and it search in tmysqinput using of  like   please Find attachment 

This is SQL

"SELECT
`doctor_details`.`id`,
`doctor_details`.`doctorName`
FROM `doctor_details` where `doctor_details`.`doctorName` Like  " + globalMap.get("request.doctorName")

[Anonymous]

but i have want txmlmap to extract their data not tmap

[Anonymous]

can u give the screen short

[fdenis]

txmlMap or tMap it's the same you have to use dynamic lookup.

I cannot add pics but you can havea look to:

https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/Ll_zYlcDgWNvb7kwSypEQQ

[Anonymous]

still not work please find Attachment 

page5.png
page6.png

[fdenis]

you forget this

"lookup Model" select "reload at each row"

add doctor name as globalmap key.

[Anonymous]

this noting return 

{"root": 

     {"g": 

         {

           "doctorName": ""

         }

     }

} 

also PFA 

page7.png

[fdenis]

you have to remove the second purple arrow who make a full match between request.doctorName and row1.doctorName

[Anonymous]

i have try also but come same output that means nothing came

page8.png

[fdenis]

[Anonymous]

same response not data will show 

page9.png