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]

Can you go into the dictionary field of u_requestor on incident table and post the screenshot which have type specifications tab?

[rhysbrennan]

This one?

We don't have one against the incident table just the task table. This is the same in development so i don't think that's the issue. I'm tempted to log a support ticket as the setup is identical.

[lSurya 24]

Hello Rhyms,

Just wanted you to know If requestor field is created on Task table! why have you created another field on an incident table? You can directly use the same requestor field on an incident form and everything will be okay.

[rhysbrennan]

It was the same field.

So fix in the end was to open the incident form in form designer, change the Requestor field to mandatory (just for something to change). As soon as I made this change the dictionary reference kicked in as it should have the first time.

[lSurya 24]

Finally, you got that