fix script to update RITM Record

[vivek11]

Hi Team,
Can someone help to update 500 ritm records fix script

A fix script needs to update the RITM records to:
Approval : Rejected
State Closed incomplete
Stage Closed incomplete

[Ankur Bawiskar]

@vivek11 

so what script did you start with and where are you stuck?

something like this

// give correct query, correct state, stage value to compare

var gr = new GlideRecord('sc_req_item');
gr.addQuery('state', '!=', 4); // Only update if not already closed incomplete
gr.setLimit(500); // Limit to 500 records
gr.query();

while (gr.next()) {
    gr.approval = 'rejected';
    gr.state = 4; // Closed Incomplete
    gr.stage = 'Closed Incomplete';
    gr.update();
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[vivek11]

Hi @Ankur Bawiskar 
Thank you for your quick reply.

I have one more issue — the related sysapproval_approver records for the same RITM are not being updated to "Rejected." Could you please help me with this?

[Ankur Bawiskar · Accepted solution]

@vivek11 

you can enhance it further.

// give correct query, correct state, stage value to compare

var gr = new GlideRecord('sc_req_item');
gr.addQuery('state', '!=', 4); // Only update if not already closed incomplete
gr.setLimit(500); // Limit to 500 records
gr.query();

while (gr.next()) {
    gr.approval = 'rejected';
    gr.state = 4; // Closed Incomplete
    gr.stage = 'Closed Incomplete';
    gr.update();

    var gr = new GlideRecord("sysapproval_approver");
    gr.addQuery("sysapproval", gr.getUniqueValue());
    gr.addQuery("state", "requested");
    gr.query();
    while (gr.next()) {
        gr.state = 'rejected';
        gr.comments = 'Auto rejected as RITM is closed';
        gr.update();
    }
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[vivek11]

Thank you @Ankur Bawiskar