Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

If script to fetch Employee's country in ServiceNow workflow

Not applicable

We have "employee_name" variable on catalog item, I have a requirement if the user selected in employee name has location.country as India then return value as yes in if script orelse no.

 

I have written below script but its not working, please advice on the same.

 


var employeeName = current.variables.employee_name;

var response = 'no';

// Query the User table to get the user's details
var userGR = new GlideRecord('sys_user');
if (userGR.get('user_name', employeeName)) {

// Check if the user's location is set and if the country is India
var locationGR = new GlideRecord('cmn_location');
if (userGR.location && locationGR.get(userGR.location)) {
if (locationGR.country == 'India') {
response = 'yes';
}

// Return the response
response;

 

10 REPLIES 10

Not applicable

I modified the code as below the if check is returning to No

AnkitaGupte_0-1727346988539.png

 

var employeeName = current.variables.employee_name;

var res = ' ';
var loca= '';

// Query the User table to get the user's details
var userGR = new GlideRecord('sys_user');

userGR.addQuery('user_name',employeeName);
userGR.query();
if(userGR.next())
{
loca = userGR.location.toString();
}
// Check if the user's location is set and if the country is India
var locationGR = new GlideRecord('cmn_location');
locationGR.addQuery('79286ca6dbc9d894ae04cf83159619bb',loca); // sysid of india country
locationGR.query();
if(locationGR.next())
{
res = locationGR.country.toString();
}
gs.info(res);

locationGR.addQuery('79286ca6dbc9d894ae04cf83159619bb',loca); // sysid of india country

 

it supposed to be 

locationGR.addQuery('sys_id',loca);

Not applicable

okay how are we checking here if the country is india or no? because I need to same for Jordan country as well

 

@Community Alums 
var emp = current.variables.employee_name;
var response = "";
var gr = new GlideRecord('sys_user');
gr.addEncodedQuery('location.country=USA^ORlocation.country=india^sys_id='+emp);// replace USA with another location
gr.query();
if(gr.hasNext())
{
response = 'yes';
gs.info('yes'); --> return yes;
}
else{
return = 'no';
gs.info('no');
}

Not applicable

Its giving me parsing error: 'return' outside of function

AnkitaGupte_0-1727684172943.png