ITSM

[KritiK]

Hi Everyone,

I have one query if anyone knows please give the response quickly.

I have a field which is a reference field, we have migrated the data using import set through transform script to map the field but the data after migrating is imported correctly but the display value is empty, record is populated and while clicking on the 'i' button the data is shown correctly but there is no display value for that field. 

I have checked the record in xml, the display value is empty but has a sys_id and i have checked the sys_id on the reference table, the record is present of that sys_id.

[Najmuddin Mohd]

HI @KritiK ,

Generally, reference fields takes the mapping of sys_ids.
Is your import set having Sys_ids of the records or the Names of those records.

If it's the second case, then
Write a GlideRecord on the target table.
query with name field.
Return the sys_id of the queried record.

If this information helps you, kindly mark it as Helpful and Accept the solution.


Regards,
Najmuddin.