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

chirag_bagdai · ‎06-21-2017

Hi Grace,

Can you please tell what is the data type of "Primary Security Affiliation" field ? and also, "Student, Student Assistant, Student Applicant" are those groups?

gnunez · ‎06-21-2017

Hi Chirag,

The data type is String and "Student, Student Assistant, Student Applicant" are just values in that field. Does that make sense?

Community Alums · ‎06-21-2017

Grace,

Start here for a good reference on GlideRecord queries:

https://www.servicenowguru.com/scripting/gliderecord-query-cheat-sheet/

You would need to do something like this:

var gr = new GlideRecord("sys_user");

gr.addQuery("u_primary_security_affiliation", "!=", "Student");

gr.query();

You'll need to add 'addQuery' lines for each of the Primary Security Affiliation type you want to exclude in the record.

Hope that gets you started!

Cheers,

Tim

gnunez · ‎06-21-2017

Thanks Tim this is a good start!