Create Workflow Approvals for a Catalog item

Go to solution
Joshuu
Kilo Sage

‎01-02-2023 09:46 PM - edited ‎01-03-2023 02:21 AM

Hi All,

 

I have a catalog item called "XXX Application Access". And we have a variable on the form of type "List collector" where users will be able to select one/more applications from cmdb_ci application table.

 

Once the request is submitted, the approval should be triggered from the service offering table.

 

So, for every CI we have a relationship in the CI relationships table. And here Parent is the CI/Application and the Child is mapped to Service Offerings table. Please find the below screen shot for reference.

 

priyarao_0-1672723935886.png

 

priyarao_1-1672724052123.png

 

So, based on this mapping we need to trigger the approval to the Approval Group from the Offerings table for the selected applications on the catalog form.

 

For example, a user has selected 6 applications in the catalog form.

 

4 application are having same approval group and the remaining 2 are having some other approval group in the service Offering table.

 

In this case, we should trigger only 2 approvals in the request for all 6 applications. 

 

one approval is for the first 4 applications since it is having the same group in the service offering table.

and the second approval is for the remaining 2 applications.

 

And it should complete all the approvals before creating catalog tasks.

 

Kindly please help me with this flow.

 

Appreciate your help.

 

Thanks & Regards,

Priya.

 

 

0 Helpfuls
  • 1,928 Views
2 ACCEPTED SOLUTIONS

Go to solution
jaheerhattiwale
Mega Sage
Mega Sage
In response to Joshuu

‎01-03-2023 09:03 PM

@Joshuu Please try below code. It should work.

 

var answer = [];

var applications = (current.variables.application_access.toString()).split(",");

for (var i = 0; i < applications.length; i++) {
    var cirel = new GlideRecord('cmdb_rel_ci');
    cirel.addQuery('parent', applications[i]);
    cirel.addQuery('type=5a17d06787f551100c80ec683cbb355e');
    cirel.addQuery("child.sys_class_name=service_offering");
    cirel.query();
   
    while (cirel.next()) {
        if(answer.indexOf(cirel.child.change_control.toString()) < 0){
        answer.push(cirel.child.change_control.toString());
        }
    }
}
 
Please mark as correct answer if this solves your issue.
Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

View solution in original post

Go to solution
jaheerhattiwale
Mega Sage
Mega Sage
In response to Joshuu

‎01-04-2023 08:35 PM

@Joshuu Remove "Catalog task" activity and add "Run script" activity and add below updated code to "Run script" activity.

 

var groups = [];
var appObject = {};
var appIdObject = {};

var applications = (current.variables.application_access.toString()).split(",");
 

for (var i = 0; i < applications.length; i++) {
var cirel = new GlideRecord('cmdb_rel_ci');
cirel.addQuery('parent', applications[i]);
cirel.addQuery('type=5a17d06787f551100c80ec683cbb355e');
cirel.addQuery("child.sys_class_name=service_offering");
cirel.query();
 

while (cirel.next()) {
    if (groups.indexOf(cirel.child.u_access_group.toString()) < 0) {
        groups.push(cirel.child.u_access_group.toString());
    }
 

    if(appObject[cirel.child.u_access_group.toString()]){
appObject[cirel.child.u_access_group.toString()].push(cirel.parent.getDisplayValue());
    }else{
        appObject[cirel.child.u_access_group.toString()] = [];
        appObject[cirel.child.u_access_group.toString()].push(cirel.parent.getDisplayValue());
    }

    if(appIdObject[cirel.child.u_access_group.toString()]){
appIdObject[cirel.child.u_access_group.toString()].push(cirel.parent.toString());
    }else{
        appIdObject[cirel.child.u_access_group.toString()] = [];
        appIdObject[cirel.child.u_access_group.toString()].push(cirel.parent.toString());
    }
}
}

for(var j=0; j<groups.length; j++){
var scTask = new GlideRecord("sc_task");
scTask.initialize();
scTask.request = current.request.toString();
scTask.request_item = current.sys_id.toString();
scTask.assignment_group = groups[j];
scTask.description = (appObject[groups[j]].toString()).replaceAll(",","\n");;
scTask.short_description = "SAAF access";
var taskId = scTask.insert();

var affectedApps = appIdObject[groups[j]];

for(var k=0; k<affectedApps.length; k++){
    var affectedCI = new GlideRecord("task_ci");
    affectedCI.initialize();
    affectedCI.task = taskId;
    affectedCI.ci_item = affectedApps[k];
    affectedCI.insert();
}
}
 
This will add the each application on new line in description
And add applications to Affected CIs related list as well
 
Please mark as correct answer if this solves your issue.
Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

View solution in original post

34 REPLIES 34

Go to solution
Joshuu
Kilo Sage

‎01-02-2023 11:38 PM

Hi @Community Alums ,

 

Could you please help me with the script as per my requirement. 

 

Thanks for the response.

 

Regards,

Priya.

0 Helpfuls

Go to solution
Community Alums
Not applicable
In response to Joshuu

‎01-02-2023 11:40 PM

Hi @Joshuu ,

 What have you tried as of now?

Can you share your script?

0 Helpfuls

Go to solution
Joshuu
Kilo Sage
In response to Community Alums

‎01-02-2023 11:59 PM - edited ‎01-03-2023 04:35 AM

Hi @Sandeep Dutta ,

 

I have created a catalog item and added application variable in it, and I want to create a workflow now. Not started anything in it. 

0 Helpfuls