Lookup using list only showing sys_id

User163016 · ‎06-02-2016

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

Slava Savitsky · ‎06-02-2016

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.

Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/

View solution in original post

Community Alums · ‎06-02-2016

First, I'd check to be sure you didn't accidentally change the display field on the sys_user_has_role table.

Next I'd look at the list layout for that reference table. Can you paste a screenshot of the reference field's dictionary entry form?

Chuck Tomasi · ‎06-02-2016

You need to set one of the fields as the display value. Configure the table (or dictionary) and set one of the fields' display=true.

You might also want to right-click and configure the form layout to include some more useful information.

User163016 · ‎06-02-2016

Thanks again Chuck!!

I will play around with the configure form to get the User information to show up in the lookup list.

Mike Allen · ‎06-02-2016

You need a display value on sys_user_has_role: