Work notes are not populated on the Form while transforming data

Ashwini Jadhao · ‎12-09-2019

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.

Harsh Vardhan · ‎12-09-2019

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();

}

View solution in original post

Harsh Vardhan · ‎12-09-2019

work notes field data store in sys_journal_field table . have you checked the "sys_journal_field" table record check the values there.

Harsh Vardhan · ‎12-09-2019

you can pass your record sysid on element id column and select the table name and then filter the record, you will see the record here. work notes field is not like string type field so what ever value you will set that will appear into sys_journal_field table.

Ashwini Jadhao · ‎12-09-2019

yes all the values are present on sys_journal_field table. but why this values are not visible on the form. Even I have increased the work not field value

Harsh Vardhan · ‎12-09-2019

its journal type field and this type of field does not hold the value , if you will update the field value using script then it will save into the journal table.

as well as on form if you will set it manually and save the form the entry will be available on sys_journal_field table.