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")

[fdenis]

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

[Anonymous]

not work sill not search  

page-3.png

[fdenis]

try the query into a MySQL editor first.

[Anonymous]

mysql editor working find and retrieve the relatively data.

[Anonymous]

not working to dynamically to passing that parameter

[fdenis]

does it work without request.doctorName parameter?

[fdenis]

can you send a screenshot of your job?

[Anonymous]

PFA for my job screen sort

page-1.png
page-2.png
page-3.png
page-4.png

[fdenis]

ok in your tmap:
for row1 click the tool.
in lookup Model select reload at each row.
in the new exp. line
click on +
add request.doctorName
in your sql query use globalMap.get("myKey")

is it Fine?