Changing the user name tagged in the Work notes or Additional comment (sys_journal_field)

stacybentley
Tera Guru

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

1 ACCEPTED SOLUTION

kamlesh kjmar
Mega Sage
Mega Sage

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 

kamleshkjmar_0-1666968384632.png

 

2. Now open the record whose user name tag you want to change and open the history > list of that record

kamleshkjmar_1-1666968491039.png

 

 

 

 

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.

kamleshkjmar_2-1666968730888.png

 

kamleshkjmar_3-1666968759161.png

 

I Hope this helps.

 

Please mark this helpful if this helps and Accept the solution if this solves your issue.

 

Regards,

Kamlesh

 

 

 

 

 

View solution in original post

5 REPLIES 5

kamlesh kjmar
Mega Sage
Mega Sage

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 

kamleshkjmar_0-1666968384632.png

 

2. Now open the record whose user name tag you want to change and open the history > list of that record

kamleshkjmar_1-1666968491039.png

 

 

 

 

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.

kamleshkjmar_2-1666968730888.png

 

kamleshkjmar_3-1666968759161.png

 

I Hope this helps.

 

Please mark this helpful if this helps and Accept the solution if this solves your issue.

 

Regards,

Kamlesh

 

 

 

 

 

Thank you Kamlesh!

 

Stacy

Your are welcome!! I am glad I could help.

Is it possible to create a Business Rule to perform the same above mentioned activity?