How to write business roles based on fields between associated tables?

[shiz]

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？

[Rafael Batistot]

Hi @shiz 

Try 

userGroup.addQuery("group.sys_user_group_type.name", typeName);

[shiz]

It seems that the data with type=organization in the sys_user_group table has not been filtered yet. After trying to modify it, the result set is still the same as before. This code doesn't seem to work.

[shiz]

If it could help me, I would be very grateful.

[Shraddha Kadam]

Hello @shiz ,

Can you share your exact requirement?