How to populate value in a field on approval table from workflow?

[thirumala2]

Hi ,

We have a requirement of populating value from workflow to a given field on approval table for managed docs .

From the below workflow run script :

@shloke04 can u help ?

[shloke04]

@thiruma 

This is really interesting, as it is working for me.

I would suggest you can connect with me on Linked In and I can look at your code and will assist you which will be quick as well.

Send me a request on below Linked in profile of me:

https://www.linkedin.com/in/shloke-srivastava-13a1b887/

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Ankur Bawiskar]

@thirumala 

update as this

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval',current.sys_id);
gr.query();
while(gr.next()){
	gr.u_managed_document = current.number.toString();
	gr.update();
}

Regards
Ankur

[thirumala2]

Hi @Ankur Bawiskar ,

Thanks for the response .I have tried this 1 also not working .Is there some other script to be added since that number field is on dms_document table and the wf run on dms_document _revision table .

[Ankur Bawiskar]

Hi,

okay workflow is on dms_document_revision table

did you check it went inside

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id',current.sys_id);
gr.query();
if(gr.next()){
    
    gs.info("inside");
    
    gr.u_managed_document = current.number.toString();
    gr.update();
}

Regards
Ankur

[thirumala2]

Hi @Ankur Bawiskar ,

No ,The message is not going inside .