topic Re: Dynamically pass value dynamically in trestquest with tmysqlinput in Talend Studio

Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Wed, 20 Jun 2018 07:51:53 GMT

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

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Wed, 20 Jun 2018 08:03:59 GMT

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

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Wed, 20 Jun 2018 08:23:54 GMT

not work sill not search

page-3.png

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Wed, 20 Jun 2018 09:33:29 GMT

try the query into a MySQL editor first.

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 05:50:36 GMT

mysql editor working find and retrieve the relatively data.

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 05:51:38 GMT

not working to dynamically to passing that parameter

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 08:01:07 GMT

does it work without request.doctorName parameter?

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 08:01:48 GMT

can you send a screenshot of your job?

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 09:20:44 GMT

PFA for my job screen sort

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

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 09:39:23 GMT

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?

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 09:59:23 GMT

but i have want txmlmap to extract their data not tmap

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 10:01:42 GMT

can u give the screen short

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 10:20:59 GMT

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

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 10:36:38 GMT

still not work please find Attachment

page5.png
page6.png

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 10:57:35 GMT

you forget this

"lookup Model" select "reload at each row"

add doctor name as globalmap key.

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 11:09:30 GMT

this noting return

{"root":

{"g":

{

"doctorName": ""

}

also PFA

page7.png

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 14:02:01 GMT

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

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 14:13:32 GMT

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

page8.png

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

fdenis — Thu, 21 Jun 2018 14:23:18 GMT

Re: Dynamically pass value dynamically in trestquest with tmysqlinput

Anonymous — Thu, 21 Jun 2018 14:30:17 GMT

same response not data will show

page9.png