quesion on script

[Srini19]

    var gm = new GlideRecord('sys_user_group');

    gm.addQuery('active', true);

    gm.query();

    while (gm.next()) {

        var gr = new GlideRecord('sys_user_grmember');

        gr.addQuery('group.name', gm.name);

        gr.addQuery('user.name', '=', "");

        gr.query();

        if (gr.next()) {

            gs.print("This group has no member----" + gm.name);

        }

    }

This query is  working fine, how do I wirte this in addEncoded query when I tried I was getting error. Please advise.

[PrashantLearnIT]

Hi @Srini19 

For your script its not required to add Encoded Query, because there are less conditions here. If there more condition logic then encoded query could be written

[Srini19]

thanks for your  reply.

No, I want to know how I can write this in encoded query.

[PrashantLearnIT]

Hi @Srini19 

Which line number you are trying to make encoded?

[Ankur Bawiskar]

@Srini19 

this should work fine

var gm = new GlideRecord('sys_user_group');
gm.addQuery('active', true);
gm.query();
while (gm.next()) {
    var gr = new GlideRecord('sys_user_grmember');
    // Use encoded query: group = group_sys_id and user is empty
    gr.addEncodedQuery('group=' + gm.sys_id + '^userISEMPTY');
    gr.query();
    if (!gr.next()) {
        gs.print("This group has no member----" + gm.name);
    }
}

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏