If script to fetch Employee's country in ServiceNow workflow

[Ankita Gupte]

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;

[Ankita Gupte]

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

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);

[Eshwar Reddy]

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

it supposed to be 

locationGR.addQuery('sys_id',loca);

[Ankita Gupte]

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

[Eshwar Reddy]

@Ankita Gupte 
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');

}

[Ankita Gupte]

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