How to map dot-walked field in transform map?

sheikhassan · ‎08-01-2016

I have pulled the Assigned_to.Mobile phone field to the cmdb_ci table.

While mapping a data to the cmdb_ci table, couldn't find the Assigned_to.Mobile phone field in the target. As, i have to map a phone number from sample data to cmdb_ci.

Moreover, how to map the dot-walked fields in transform map?

Can anyone help on achieving this.

Thanks in advance.

sheikhassan · ‎08-02-2016

Thank you Pradeep, Ashutosh and Abhinay for your timely responses.

Abhinay, i just modified the script and made it work

Here is the script:

var gr= new GlideRecord("sys_user");

gr.addQuery('name',source.u_assigned);

gr.query();

while(gr.next())

{

gr.mobile_phone=source.u_phone;

gr.update();

}

View solution in original post

Pradeep Sharma · ‎08-01-2016

Hi Sheik,

You mean you want to update mobile number data in referenced table. If yes then you need to handle this via script.

http://wiki.servicenow.com/?title=Transform_Map_Scripts

Ashutosh Munot1 · ‎08-01-2016

Is the field type same, and yes script is required as pradeep said.

Abhinay Erra · ‎08-01-2016

You cannot directly map this.You will have to query on user table and fill in the phone number there.

var gr= new GlideRecord("sys_user");

gr.get(source.<filed name of assigned_to>);

gr.mobile_phone=source.<phone number field name>;

gr.update();

sheikhassan · ‎08-01-2016

Thanks for your response.

Tried this but no luck.

Please find the sample..This i have to map to assigned to field and assigned_to.mobile phone in cmdb_ci table.