Reference field Qualifier to show right column.

[Ram050670]

Hi, i am looking for solution on Portal view but i am looking to show members of the group using reference field. its showing Created and then User, i want User to be only shown to select

can any one help on this ?

[Brad Bowman]

'Created' is an unusual field to be displayed without specifying it.  If you view a group record in the native UI is created_by/on the Display field - does it appear below 'Group' in the gray header bar?  If so, change the Display field on the table to User and you're all set.

[Ram050670]

@Brad Bowman  

is there a way to use the sys user table and get the members of group?

[Vishal Birajdar]

Hi @Ram050670 

Can you try using "lookup select box" on "Group Member"

Lookup field - User

[Ram050670 · Accepted solution]

i actually used sys user table and with advanced reference qualifier.

javascript:'active=true^sys_idIN'+getIDs("group sys id"); function getIDs(grp){var m=GlideUserGroup.getMembers(grp);var ids=''; while (m.next()){ids+= (m.user+',');} return ids;}

 Its working!!