Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 07:02 PM
I have the following business roles.
var groupName = "G2U%";
var typeName = "Organization";
var f = 1;
//現在のキャラクタの下にあるすべてのuserを取得して、に戻ります
var userGroup = new GlideRecord("sys_user_grmember");
userGroup.addQuery("user",u);
userGroup.addQuery("group.name","NOT LIKE", groupName);
userGroup.addQuery("sys_user_group_type.name",typeName);
//userGroup.addQuery("group.name","<>",exceptGroup_1);
//userGroup.addQuery("group.name","<>",exceptGroup_2);
userGroup.query();
while(userGroup.next()){
var strGroup = userGroup.group;
// get group's user info
var g_member = new GlideRecord("sys_user_grmember");
g_member.addQuery("group",strGroup);
g_member.addQuery("user","<>",u);
g_member.query();
while(g_member.next()){
var strUser = g_member.user.sys_id.toString();
answer[f] = strUser;
f++;
}
}
But, userGroup.addQuery("sys_user_group_type.name",typeName) :This code is not effective.
The following are the field definitions for the table:
How to modify the code to filter data with type 'organization' in the 'sys_user_group' table?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 08:19 PM
Hello @shiz ,
Use the below code. This works for me.
var groupName = "G2U%";
var typeName = "Organization";
var f = 1;
var answer = [];
//現在のキャラクタの下にあるすべてのuserを取得して、に戻ります
var userGroup = new GlideRecord("sys_user_grmember");
userGroup.addQuery("user", gs.getUserID());
userGroup.addQuery("group.name", "NOT LIKE", groupName);
userGroup.addQuery("group.type", 'f3dfc27ac32222103e1a76d4e40131c3'); // sys_id of organization
//userGroup.addQuery("group.name","<>",exceptGroup_1);
//userGroup.addQuery("group.name","<>",exceptGroup_2);
userGroup.query();
while (userGroup.next()) {
var strGroup = userGroup.group;
// get group's user info
var g_member = new GlideRecord("sys_user_grmember");
g_member.addQuery("group", strGroup);
g_member.addQuery("user", "<>", gs.getUserID());
g_member.query();
while (g_member.next()) {
var strUser = g_member.user.getDisplayValue().toString();
gs.info("sys_id - "+strUser);
answer[f] = strUser;
f++;
}
}
Output -
Group with members -
Script output
If my response was helpful, please mark it as correct and helpful.
Thank you.
Thank you.
10 REPLIES 10
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 08:31 PM
Thank you very much for your help.