Incorrect Timestamp of worknotes in activity

[ChennamsettP]

Hi All,

  We have migrated Worknotes/Comments from OOB table to Custom table using a fix script.

  Worknotes of OOB table record is copied to Custom table record, but the timestamp of Custom record worknotes activity log is showing with the time at the record is opened for the first time instaed of original timestamp in OOB record.

Can anyone help me with this please..?

[VikMach]

Hi @ChennamsettP,

If you wish to move work notes or comments from one table record to another. Simply open Journal Entry table (sys_journal_field.LIST) and move the desired record from one table to another and change the Element ID (Element ID is Sys ID of the record) to the desired record. It will get attached to the desired table with complete element with its original time stamp.

On a side note whether you are doing this in the same instance or moving the complete Worknotes/Comments to another instance. Just update those 2 fields in the Journal Entry table and it will show the correct time stamp. A slight variation in seconds is possible because every instance is running of different time zones some time.

Hope this helps.
Let me know if it worked!

Regards,
Vikas K

[Ankur Bawiskar]

@ChennamsettP 

how did you copy the timestamp?

you should copy the sys_created_on for that journal entry and put that into your custom table's sys_created_on

If my response helped please mark it correct and close the thread so that it benefits future readers.