Script include to query a record and set the value of specific field

Sri56
Tera Contributor

Hi Team,

We need a script include to query 'sysapproval_approver' table and check if approval type is parallel.

For those records, we need to set the field 'parallel approvals intiated' as true from client script by calling above script include.

below screenshot is for your reference:

find_real_file.png

Please help with the code

Thanks,

Sri

 

34 REPLIES 34

mahendra9315@gmail.com

please join

Click here to join the meeting

Thanks,

Sri

Sri56
Tera Contributor

Hi Mahendra,

We achieved this scenario.

Thanks for the help!

Hi Mahendra,

Did you get any clue as a solution?

Please help!

Thanks,

Sri

Hi Mahendra,

I'm getting a confirmation message.

After that, its not updating.

I even cant see the logs.

its because of the line:

sysApprovalGR.addQuery("sysapproval_approver", parent.getUniqueValue());

i changed to 

sysApprovalGR.addQuery("sysapproval", parent.getUniqueValue());

Since 'sysapproval' is the backend name.

Still no luck.

Please do help me here.

Thanks,

Sri