Get RITM number in worflow

Brian Lancaster · ‎06-10-2014

Is there a way RITM number to use in a script during the workflow? I know its available in the workflow as I can use it in a mail script during the workflow.

akt_snow · ‎06-10-2014

Hi Brian,

The field name that you are referring to is incorrect. The label is Approval for but field name is 'sysapproval'

try using the below code instead, it will work.

var gr = new GlideRecord('sysapproval_approver');

gr.addQuery('sysapproval', current.sys_id);

gr.addQuery('state', 'approved');

gr.query();

If this resolves the issue, then please mark it answered and close the thread.

Thanks,

Avneet

View solution in original post

User151789 · ‎06-10-2014

Like Mark was saying, if you change the line

gr.addQuery('approval_for', current.number)

to

gr.addQuery('approval_for', current.sys_id)

then it should work.

From what I have seen, if you put in a query that doesn't quite work, GlideRecord will bring back a lot more records than you want.

Brian Lancaster · ‎06-10-2014

As in my previous replay chaining it to current.sys_id still returned 300+ records.

User151789 · ‎06-10-2014

Is that by chance tied to the looping workflow you were asking about on the other thread? Maybe something is wrong there.

Brian Lancaster · ‎06-10-2014

no this is a completely different workflow

Mark Stanger · ‎06-10-2014

Try this...

var gr = new GlideRecord('sysapproval_approver');

gr.addQuery('document_id', current.sys_id);

gr.addQuery('state', 'approved');

gr.query();

while(gr.next()) {

var approver = gr.approver;

workflow.scratchpad.approved_by = approver;

gs.log('Approved by : ' + approver);

}