User_name missing in sys_user table?

[rhysbrennan]

Hi wondering how this happened in our production environment. I was modifying the sys_user table dictionary option to allow searching against a user ID instead of our current name and email address for the requester field in incidents.

In our Dev environment i was able to change the reference collection fine however the user_name is not included as an available table column in the production environment. When I tried to add a new table column it prefixes the attribute with u_user_name so I know I'm going in the wrong direction.

I know the data is there because it's colease in the SSO and available to view against users. I just don't know how to add the column in the dictionary. There are a lot of other columns missing as well.

I'll grab some screenshots if needed.

[rhysbrennan]

Thanks that makes sense.The sys_user table is correct and matches our Dev environment.

This is where I made the change that worked perfectly in Dev.

PROD:

DEV:

[antin_s]

Yes, are you saying it is not working in PROD or you dont see your changes?

[rhysbrennan]

I don't see the change under incidents, however it does work in the task form

Task (working):

Incident (not working):
What is returned by the reference field is the Name and Email Address (not in the screenshot)

[antin_s]

Are you sure the Reference Qualifier for the Requester field allows you to be selected as the user? In other words, are you able to search by name and yourself?

[rhysbrennan]

It works when I use the email or name: