How to change the state of a requested catalog item based off status of manager of a group

[gunishi]

Hi all, 

I have the following requirements:

• Once request is submitted approval should go to Manager of the group ‘Food Warriors’.

• Approval Conditions-

    o If manager of the group is missing/inactive then request should get closed cancelled.

    o If manager of the group rejects the requests then it should be moved to rejected state.

How would I implement this?

For the first task I had initially added an approval - user task to my workflow and added the following script:

answer = [];

var gr = new GlideRecord('sys_user_group');

gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');

gr.query();

while(gr.next()){

var mng = gr.manager;

}

answer.push('mng');

However, I then realised that I wouldn't be able to implement the last two bullet points. Workflow is the tool that I am struggling the most with on ServiceNow so any help would be greatly appreciated. 

Kind regards , 

G

[AnveshKumar M · Accepted solution]

@gunishi Please refer the below script for IF Activity

answer = ifScript();

function ifScript() {
    var gr = new GlideRecord('sys_user_group');
    gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');
    gr.query();
    if (gr.next()) {
        return 'yes';
    }
    return 'no';
}

And in your Approval script, I corrected a mistake.

answer = [];
var gr = new GlideRecord('sys_user_group');
gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');
gr.query();
var mng = '';
if(gr.next()){
var mng = gr.manager;
}
answer.push(mng);

[Harsh_Deep · Accepted solution]

Before going for approval activity in WorkFlow, please have another IF activity where you check if the Group manager is Missing or Inactive-

in the IF block use this Script 

answer = ifScript();

function ifScript() {
    var gr = new GlideRecord('sys_user_group');
    gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');
    gr.addQuery('active', 'ture');
    gr.query();
    if (gr.next()) {
        return 'yes';
    }
    return 'no';
}

 IF manager is available link to Approval Activity otherwise set the state to closed complete using set values activity the end the flow.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.👍

[AnveshKumar M]

Hi @gunishi 

Before going for approval activity in WorkFlow, please have another IF activity where you check if the Group has manager or not, IF manager is available link to Approval Activity otherwise set the state to closed complete using set values activity the end the flow.

Please mark my answer helpful and accept as solution if it helped you 👍✔️

[AnveshKumar M · Accepted solution]

@gunishi Please refer the below script for IF Activity

answer = ifScript();

function ifScript() {
    var gr = new GlideRecord('sys_user_group');
    gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');
    gr.query();
    if (gr.next()) {
        return 'yes';
    }
    return 'no';
}

And in your Approval script, I corrected a mistake.

answer = [];
var gr = new GlideRecord('sys_user_group');
gr.addQuery('sys_id', 'c9666099973131104a02bcb3f153afb8');
gr.query();
var mng = '';
if(gr.next()){
var mng = gr.manager;
}
answer.push(mng);

[AnveshKumar M]

Hi @gunishi 

OOTB Closed cancelled will not be there. Instead You can set the stage  (not state) to Request Cancelled and state to Closed Skipped

[gunishi]

Hi @AnveshKumar M 

This is brilliant, thank you so much for your time and help today. 

Kind regards, 

G