We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Add more criteria to encoded query

purdue
Kilo Sage

Hello,

I need to exclude HR groups to this query please assist.

Thanks,

Chad

Add exclusion of HR Groups Type is Human Resources and Parent is not HRSD.

typeNOT LIKE7a5370019f22120047a2d126c42e705c^parent!=904c25b01b00525c62cb2139b04bcb34

 

To

groupsExclusion: function() {
var groupSysIDs = [];
query = 'sys_idIN' + gs.getProperty("groups.to.exclude");
var group = new GlideRecord('sys_user_group');
group.addEncodedQuery(query);
group.query();
while (group.next()) {
groupSysIDs.push(group.sys_id + "");
}
return groupSysIDs;
},
17 REPLIES 17

Brad Bowman
Mega Patron
query = 'sys_idIN' + gs.getProperty("groups.to.exclude") + '^

typeNOT LIKE7a5370019f22120047a2d126c42e705c^parent!=904c25b01b00525c62cb2139b04bcb34';

Hello,

Unfortunately that does not work.  Thanks for the assistance.

Screenshot 2024-10-16 at 2.35.54 PM.png

Screenshot 2024-10-16 at 2.39.50 PM.png

Screenshot 2024-10-16 at 2.42.05 PM.png

Hello,

Unfortunately that does not work.  Thanks for the assistance.

Screenshot 2024-10-16 at 2.35.54 PM.pngScreenshot 2024-10-16 at 2.39.50 PM.pngScreenshot 2024-10-16 at 2.42.05 PM.png