Update custom field in sys_attachment table based on approval using BR

AKASH BANERJEE
Mega Guru

‎12-07-2023 11:23 PM

Hi All,

 

We have the below requirement in Servicenow slm module.

"Whenever the task is rejected the attachments are mandatory for suppliers before submitting the task again, for that we want to update custom field review in sys_attachment table "

 

-We have created one custom field 'review' in sys_attachment table with default value 'Not reviewed'

-The below business rule has been created

AKASHBANERJEE_0-1702019728776.pngAKASHBANERJEE_1-1702019761676.png

 

-The below cross scope privilege has been created

AKASHBANERJEE_2-1702019838903.png

 

-The issue is when the BR is active, then even if the task is rejected, then it is not updating the review field value to 'reviewed' in sys_attachment table.

-Note: The task are created as a part of record producer so we cannot check the mandatory attachment check box

 

Please let me know if anyone having any solution on this.

 

 

 

0 Helpfuls
  • 278 Views
1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

‎12-08-2023 03:54 AM

Are you getting one or both logs?  If not one or both of your conditions are not being met by your test case, so make sure when 'the task is rejected'  - whatever action you are taking to do that -  the Action type field on the task record = Upload Document, and the Approval field  = Rejected.

0 Helpfuls