question Re: GlideRecord/Script in User Criteria in ServiceNow AI Platform forum

GlideRecord/Script in User Criteria

patricklatella — Thu, 25 Jan 2018 18:21:18 GMT

Hi friends,

I'm building a User Criteria and need to have the script check the value of field on the logged in user's record in sys_user.

Trying a couple ways to do this and not finding the correct script. Anyone see why this isn't working? the top part that is querying to get the gr.u_region is working fine. It's the getDomain part that does not seem to be working. The field on the sys_user table I'm looking to see if it "== 'CTS'" is [u_ad_domain].

Thanks!

answer();

function answer(){

var loc = gs.getUser().getRecord().getValue('location');

var gr = new GlideRecord('cmn_location');

gr.get(loc);

var getDomain = new GlideRecord('sys_user');

getDomain.addQuery('sys_id',gs.getUserID());

getDomain.query();

if(gr.u_region == 'EMEA' && getDomain.u_ad_domain == 'CTS'){

return true;

}

Re: GlideRecord/Script in User Criteria

VaranAwesomenow — Thu, 25 Jan 2018 18:31:28 GMT

can u pls explain the exact requirement of this user criteria.

Re: GlideRecord/Script in User Criteria

patricklatella — Thu, 25 Jan 2018 18:35:13 GMT

Hi Anil,

thanks for the reply. I'm looking to use this User Criteria to restrict the accessibility of a catalog item to users in our company who have a specific region and AD Domain as specified on their user record.

Re: GlideRecord/Script in User Criteria

SanjivMeher — Thu, 25 Jan 2018 18:50:37 GMT

You dont need the scripts lines which are strike out.

answer();

function answer(){

var loc = gs.getUser().getRecord().getValue('location');

var gr = new GlideRecord('cmn_location');

gr.get(loc);

var getDomain = new GlideRecord('sys_user');

getDomain.addQuery('sys_id',gs.getUserID());

getDomain.query();

if(gr.u_region == 'EMEA' && getDomain.u_ad_domain == 'CTS'){

return true;

}

Re: GlideRecord/Script in User Criteria

SanjivMeher — Thu, 25 Jan 2018 18:53:27 GMT

Added one correction to script

answer();

function answer(){

var getDomain = new GlideRecord('sys_user');

getDomain.addQuery('sys_id',gs.getUserID());

getDomain.query();

if(getDomain.location.u_region == 'EMEA' && getDomain.u_ad_domain == 'CTS'){

return true;

}

Re: GlideRecord/Script in User Criteria

SanjivMeher — Thu, 25 Jan 2018 18:54:20 GMT

Actually this is perfect

answer();

function answer(){

var getDomain = new GlideRecord('sys_user');

getDomain.addQuery('sys_id',gs.getUserID());

getDomain.query();

if (getDomain.next())

{

if(getDomain.location.u_region == 'EMEA' && getDomain.u_ad_domain == 'CTS'){

return true;

}

Thanks,
Sanjiv

Re: GlideRecord/Script in User Criteria

Shishir Srivast — Thu, 25 Jan 2018 18:55:13 GMT

we need highlighted line as well.

var getDomain = new GlideRecord('sys_user');

getDomain.addQuery('sys_id',gs.getUserID());

getDomain.query();

if(getDomain.next()){

}

Re: GlideRecord/Script in User Criteria

VaranAwesomenow — Thu, 25 Jan 2018 18:57:28 GMT

Ok based on my understanding of the requirement below script should work.

answer = checkUser();

//gs.print(checkUser());

function checkUser() {

var return_flag = false;

var grUser = new GlideRecord('sys_user');

grUser.addQuery('sys_id', gs.getUserID());

grUser.query();

if(grUser.next()) {

if (grUser.location.u_region == 'EMEA' && grUser.u_ad_domain == 'CTS') {

//if (grUser.location.name == '100 South Charles Street, Baltimore,MD') {

return_flag = true;

}

return return_flag;

}

Re: GlideRecord/Script in User Criteria

patricklatella — Thu, 25 Jan 2018 21:47:14 GMT

hey everyone, thanks so much for the input! At first I tried each of these scripts and none worked...but I'm wondering if there's a funny issue related to our recent upgrade in DEV to Jakarta. To create my User Criteria record I did an "Insert & Stay" from an existing record, as opposed to creating "New". Then tried the above scripts above with no luck.

When I went ahead and just created a User Criteria just from "New", both Anil's and Sanjiv's scripts work.

Not sure if that's expected behavior, but good to know moving forward.

thanks guys!

Re: GlideRecord/Script in User Criteria

VaranAwesomenow — Thu, 25 Jan 2018 22:20:23 GMT

good to know Patrick

Re: GlideRecord/Script in User Criteria

Chris Sanford1 — Wed, 22 Apr 2020 17:06:07 GMT

We were creating a similar script (a little different) and were having some issues. We resolved them by replacing "gs.getUserID()" with "user_name". We did find this docs site:

https://docs.servicenow.com/bundle/orlando-it-service-management/page/product/service-catalog-management/task/t_CreateAUserCriteriaRecord.html

and that's where they recommended the user_name. They specifically advise against gs.getUser() which I assumed would also apply to gs.getUserID(). It sounds like you got this working anyways but just an FYI on what we found.

Re: GlideRecord/Script in User Criteria

patricklatella — Wed, 29 Apr 2020 20:17:22 GMT

Good to know, thanks Chris!