How to query the user table to return the users who fall under certain categories

gnunez · ‎06-21-2017

Hello all,

I am trying to make a catalog item available to certain users. I was recommended to use the advanced check box under user criteria and query the user table to return the users who fall under certain categories. I can do this in two ways, first we have a field in our user profiles called "Primary Security Affiliation" and I am trying to exclude if those users are under Student, Student Assistant, Student Applicant, or I can also exclude those without a job code since our students have that as empty.

Anyone who guide me in the right direction because I'm new with all the scripting. We are on Istanbul UI16.

Thanks in advance,

Grace

Abhinay Erra · ‎06-21-2017

Use this code, it should work now

checkUsers();

function checkUsers(){

var gr= new GlideRecord('sys_user');

gr.addEncodedQuery('<add your encoded query here>'); //here you will need to set you conditions in the filter and then copy the query. refer section3 in this link Encoded Query Strings - ServiceNow Wiki

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

gr.query();

if(!gr.hasNext()){

return true;

}

else{

return false;

}

View solution in original post

Abhinay Erra · ‎06-21-2017

Glad it worked!