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.

[lSurya 24]

yes please. if you can post screenshots here..

[Chuck Tomasi]

Hi Rhys,

Have you checked sys_user's dictionary entries...

It could be that the field may be marked active=false. It could be that it's just missing from the form and/or list.

[rhysbrennan]

Hi Chuck,
Maybe I had just been looking at it wrong all along but yes the user_name is in the table. My mistake

The issue that caused the investigation is still current however, under the incident form I want to look up by user_name.

So I went to User Administration - Users, and configured the dictionary completer columns to use the user_name.

User_name is set and it works on ctasks but this does not change the behaviour on incidents:
task (working):

Incident (not working):
Edit: what is shown is the Name and Email Address (not in the screenshot)

So to following the bouncing ball on the requester field:

Opening the user table from that page:

Configure the dictionary:

And now I'm lost:

How did we get to this table and not sys_user?

If I change the completer columns to user_name instead of name it still doesn't work.

[antin_s]

Hi Rhys,

At this line "Configure the dictionary:" (in the below snapshot), you are looking at the Dictionary of 'sys_db_object' table and not 'sys_user' table. Please open the sys_user table form and do 'Configure'.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin