- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2019 08:43 PM
Hi,
I am importing data from london to madrid by transform map.All the data is imported properly except Work notes.
Issue is on the tables list view I can able to see work notes data but when I open the record then the work notes field is empty.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2019 10:19 PM
try it by onBefore transform script.
eg:
var gr= new GlideRecord('your target table');
gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record
gr.query();
if(gr.next()){
gr.work_notes= source.<work note field >;
gr.update();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2019 10:11 PM
directly by field mapping

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2019 10:19 PM
try it by onBefore transform script.
eg:
var gr= new GlideRecord('your target table');
gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record
gr.query();
if(gr.next()){
gr.work_notes= source.<work note field >;
gr.update();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2022 07:24 PM - edited 12-27-2022 07:32 PM
Hi @Harsh Vardhan and @Ashwini Jadhao ,
I am importing the project records to pm_project table from the project template. This is first time insert to pm_project table and there are no Project number created yet. Once I import the data via import set the records will get the project number value.
All the fields are imported successfully, except the work notes field. That's how I ended at this post.
I see the data related to my records in sys_journal_field table.
I am not using any script , I have done direct field mapping only.
My source table is u_latest_project_import and target table is pm_project.
In the script you have provided,
gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record
what field name should I provide?
I am new to ServiceNow. Pleas help me , how to populate data in work notes field of Project form.
Thanks,
Talya