How to get all group names from sys_user_grmember table through client scripts.

[Navya8]

Hello,

I have tried getting group names from the sys_user_grmember table by querying through email of user.

However, I am getting sysids of groups of a user. 

I have used the following client script.

Thanks in advance 

Navya

..................Client Script.....................................................................

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}

var groups = [];

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('user.email', g_form.getValue('email'));
gr.query();

while (gr.next())
{
groups.push(gr.group);
}
alert(groups);

[Ankur Bawiskar]

Hi,

Thanks for the update

Regards
Ankur

[Ankur Bawiskar · Accepted solution]

Hi,

please use while(gr.next()) instead of if(gr.next())

Regards
Ankur