I want to populate work notes field from the comments field in alm_hardware table.

SamiranD
Tera Contributor

I want to populate work notes field from the comments field in alm_hardware table. So that it directly gets logged in activities filter. I want to do this using scripting. Please help

13 REPLIES 13

SuyashJ41731830
Tera Contributor

Hi
@SamiranD 
Create a Business rule on alm_hardware table

current.work_notes = current.comments;
This will complete your requirement

If my response helped please mark it correct
Thanks and Regards,
Suyash

OlaN
Giga Sage
Giga Sage

Hi,

Why would you want to copy the data from the comments to the work_notes?

Seems excessive.

Isn't it easier to just add the comments to the activities filter?

SamiranD
Tera Contributor

Just a business requirement i got.

For it to work, and assuming it is the String field "comments" you are referring to (not a journal field like Addititonal comments) you will need to change the dictionary on the comments-field (derived from the alm_asset table) and remove the "no_audit" flag.
After that, changes to the comments field will be shown in the activitiy stream (if selected).

comments-dictionary-entry.png