UserInfo Table - Is not visible in AOT

Finance and Operations/AX Developer Forum
1

Hi,

I would like to add a new field to the above Table (Say the Department Name). But it is not visible in the AOT.

My issue is, we have lot of users and at times we don’t know who the User is and which Dept. he belongs to?

Also at times we need to sort all users to see them together based on Dept.

Regards

Thomas Philipose

2

It’s a system table. You can find it under AOT > System documentation > Tables, nevertheless you’re not allowed to change the schema of system tables. But you can modify SysUserInfo table. Or create a new mapping table.

(Question moved to the Developer Forum.)

3

Dear Martin,

Sorry, I don’t know how to create a new Mapping. If I create a new Mapping table, will it help me to input the Department Name of each user through the SysUserInfoPage form and also to sort/filter on this field?

Regards

Thomas Philipose

4

The mapping table would contain references to primary keys of tables being mapped (user ID and department ID in this case). You surely can join such a tables with other tables for filtering or any other purpose.