Using Glide Query in transform map script to retrieve values and update in target record

[Geeta5]

I have requirement where in transform map script(here Source table: staging table and target table : cmdb_ci) I have to check certain values(application_owner, application name)  from sc_req_item table based on a match of 'alert id' and get values from sc_req_item table and update in target table(cmdb_ci).

I have written below code in Transform map script but I am not able to fetch values from sc_req_item table.The if loop (line  19) is getting executed i.e condition evaluates true, but I am not able to get value of 'Application_owner' , 'application_name'(line 20,21 not returning value). Please suggest how to achieve this.

[Sagar Pagar]

Try with logs.

gs.log(gr_req.variable_pool.application_owner);

gs.log(gr_req.variable_pool.application_name);

if(gr_req.next()){

application_owner = gr_req.variable_pool.application_owner;

application_name= gr_req.variable_pool.application_name;

}

target.application_owner= application_owner;

target.u_application_name = application_name;

[MrMuhammad · Accepted solution]

Hi @Geeta, 

if application_owner and application_name are variables on sc_req_item table then update below lines as.

application_owner = gr_req.variables.application_owner;

application_name= gr_req.variables.application_name;

Thanks & Regards,

Sharjeel

[Geeta5]

Thanks Muhammad, it worked.

[MrMuhammad]

Happy to help. Have a great weekend 🙂

[MrMuhammad]

Please select appropriate response as correct as it is reference for others with the similar problem in the future.