sys_user_grmember field reference qualifier

Southsayer
Tera Expert

Hi guys,

I have a list collector field type variable referencing to sys_user_grmember

I didn't put any reference qualifier but still in when I try to search in the variable so it's just displaying (created by) and not the names.... How to handle this? What reference qualifier I can put?

 

Capture.PNG

6 REPLIES 6

Sagar Pagar
Tera Patron

Hi @Southsayer,

 

To see the name you have to make the User column/field display as true.

 

Thanks,
Sagar Pagar

The world works with ServiceNow

ersureshbe
Giga Sage
Giga Sage

Hi, Can you check the field type? If it's look up select field you should check the look up value field configured with created field?

Regards,
Suresh.

Community Alums
Not applicable

Hi, You can set up variable attributes for this. you have to use ref_ac_columns in order to show other fields in the lookup.

 

bhavaniy_0-1669295523179.png

 

 

Check out the below links for the same:

https://docs.servicenow.com/bundle/quebec-employee-service-management/page/product/service-catalog-m...

https://www.servicenow.com/community/developer-forum/use-ref-ac-columns-in-variable-attribute/m-p/20...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0748319

 

Please mark my response as helpful/correct if this helps

 

Mohith Devatte
Tera Sage
Tera Sage

Hello @Southsayer ,

Go to sys_user_grmember table list view and do a right click on any of the column and click on configure-->table like below

Screenshot 2022-11-24 at 18.56.11.png

2) Then in the columns search for user column and set it to display true like below 

Screenshot 2022-11-24 at 18.57.07.png

Hope this helps 

mark my answer correct if this helps you 

Thanks