Return 'User' name from 'sys_user_grpmember' table using Advance Reference Qualifier

[chatsaurav19]

Hi All,

I am unable to return the 'user' name from the 'sys_user_grpmember' table using Advance Reference Qualifier for a Catalog Variable Field.

Any idea what exactly do I need to change?

Advnc Ref Qualifier:::

Script Include:::

Reagards,

Saurabh Chatterjee

[Harish KM]

Hi @chatsaurav19 in your advanced qualifier your passing a variable which is not passed in the function of Script Include. it should be

getUsers: function(grpName)

{

line 9 should be

grUsers.addQuery('group.name',grpName);

}

[Parth_Poriya]

Hi

Change line no. 9 to

grUserGr.addQuery('name','ISSUE MGMT FP POC');

And Line no. 13 to

arr.push(grUserGr.user.getDisplayValue())

and return arr;

[swathisarang98]

Hi @chatsaurav19 ,

Change the field reference to sys_user  where you are calling the script include

in script include line number 13

arr.push(grUserGr.getValue('user').toString());

return 'sys_idIN' +arr.toString();

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang