Reference variable is showing created time instead of record name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 10:04 AM
I have variable which is referencing to the group member table and on the platform, it is showing the user name, user email and user id as configured but the same is not working on portal.
When I try to select user, it is showing the created time instead of their name and email id's.
Unable to set the display column as user field on group member table.
Any thoughts?
- Labels:
-
Service Catalog
-
Service Portal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 12:20 PM
Sruthi,
any idea on how can I show the user name, user email, user id in list view as we show in native UI.?
Also if you can give me the exact reference qualifier to show only users from group where current logged in user is part of will be helpful for me.
when I give the condition like Group is dynamic one of my groups then same user is showing multiple times.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 12:39 PM
use below in variable attribute ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user;user.email;user.user_name,ref_ac_columns_search=true.
Your reference qualifier seem to be correct and it would show users multiple times if the same user is in multiple teams.
To show it only once, you might have to use "user" as the reference table and use script include to query group member table to get only the list of users that current user is part of. You would link the script include in the reference qualified by marking advanced

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 11:31 AM
Hi,
What you mean you are not able to set Display value on group member table? It should be User or Group field
Thank you
Prasad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 11:53 AM
for user column on group member table I am unable to set the display to true. I think we need to first set the display column on sys_user table first then we would be able to select the user column as display for group member table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 12:50 PM
You should change the Display value of that table to the User ID field.