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

Mark Stanger · ‎06-10-2014

I'm not sure what you're looking for specifically, but the RITM number should be available to any script within its corresponding workflow simply by calling 'current.number'.

Brian Lancaster · ‎06-10-2014

We are tying to query the sysapproval_approver table go the the approver. We are trying this but are still getting 300 records back but we should only have one. There could be 2 approvers for the RITM but only one has to approve.

var gr = new GlideRecord('sysapproval_approver');

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

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

gr.query();

while(gr.next()) {

var approver = gr.approver;

workflow.scratchpad.approved_by = approver;

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

}

Mark Stanger · ‎06-10-2014

Since you're dealing with sys_id values, I think you want 'current.sys_id' instead of 'current.number'.

Brian Lancaster · ‎06-10-2014

That is still pulling 300 + records