- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2022 07:25 AM
Hi,
We have to update the user name tagged in Work notes and Additional comments. I found all the records in the sys_journal_field table and changed the Created by field to the new user name.
The Activity field still show the old user name.
Has anyone change the user name tagged in the Work notes and Additional comments?
Thank you,
Stacy
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2022 07:53 AM
Hi @stacybentley ,
User name that you see tagged in Work notes and Additional comments do not come from created by field of sys_journal_field, rather it comes from sys_history_set table. I won't recommend you do any change in this as you will have to deactivate the ACLs running on this table.
But Just for demonstraction, this is how you can do it :
1. Go to ACL and deactivate write ACL writen on sys_history_line table
2. Now open the record whose user name tag you want to change and open the history > list of that record
3. Now search for laberl additional comments in Audit History related list and change the User Name vield value. Same name will reflect in the record notes now.
I Hope this helps.
Please mark this helpful if this helps and Accept the solution if this solves your issue.
Regards,
Kamlesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2022 07:53 AM
Hi @stacybentley ,
User name that you see tagged in Work notes and Additional comments do not come from created by field of sys_journal_field, rather it comes from sys_history_set table. I won't recommend you do any change in this as you will have to deactivate the ACLs running on this table.
But Just for demonstraction, this is how you can do it :
1. Go to ACL and deactivate write ACL writen on sys_history_line table
2. Now open the record whose user name tag you want to change and open the history > list of that record
3. Now search for laberl additional comments in Audit History related list and change the User Name vield value. Same name will reflect in the record notes now.
I Hope this helps.
Please mark this helpful if this helps and Accept the solution if this solves your issue.
Regards,
Kamlesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2022 08:39 AM
Thank you Kamlesh!
Stacy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2022 08:54 AM
Your are welcome!! I am glad I could help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2024 02:52 AM
Is it possible to create a Business Rule to perform the same above mentioned activity?