Lookup using list only showing sys_id

[User163016]

I have a catalog variable that is referencing the sys_user_has_role table.   What I'm trying to accomplish is having a list that only includes ITIL users, so when I click on the lookup using icon, I want users to show.   When I'm in the form and click on Lookup using list (magnifying glass) to search for a user, all I see is sys_id's listed.  

Also if I select one of the sys_id's it just fills in Created......

How can I display user information in the lookup list and then have the name display in the field when selected?

Thanks in advance

[User163016]

Thank you all!  

I set display=true on the user field within the sys_user_has_role table and that fixed the issue of the "Created..." showing in the field on the form.

[Slava Savitsky · Accepted solution]

As others have already pointed out, marking User field as the Display value would give the desired result. What you should be aware of is that this change is going to have impact on all reference fields and catalog variables throughout the system that point to the User Roles [sys_user_has_role] table. This may not necessarily be desirable. Moreover, the value of the variable will be the sys_id of a user-to-role relation from the many-to-many table, which is not really useful for further processing of the request. A better solution, in my opinion, would be to switch your reference to the Users [sys_user] table and use roles=itil as Reference qualifier.

[User163016]

Excellent point Slava!  

I set it up and saw several names that are listed multiple times because they are in several workgroups that have the ITIL role.   I was just playing around with using the sys_user table instead but couldn't quite figure out how to make it work.   I dropped active=true^roles=itil^EQ in as the Reference qual and it is showing me exactly what I needed.

Thanks!

[Gary Fawcett1]

Hi,

I have the exact same issue, but with San Diego.  The table has a Display field set, but still we get this?

God know what to do 😞

[Slava Savitsky]

What is the name of the table where your reference field is located? And what is the name of the table the reference field is pointing to? What field is set as the display field for the latter table? What does the reference field look like when it is not empty?