Lookup field using USERS table not displaying the "Display Field" in List Page

PHPMaker General Discussion (PHPMaker)
1

PHPMaker v2025.9

I have a module where I set my field RECIPENT’s Lookup table pointed to USERS table (I use this table for my project login as well) with multiple select enabled. I set the USEREMAIL as link field and USERNAME as Display Field.

If I login as Super Admin, there is no issue displaying the value in Display Field.

If I create a normal user role, even if I checked ALL the permission for my USERS table, it doesn’t show the value of Display Field in the List Page. It can only show correctly when in the Edit Page.

I checked the Debug, the query is wrong for the List Page (login as non-administrator but given full permission to USERS table) as it only show my own record although I have granted full permission.

SELECT [USEREMAIL] AS [lf], [USERNAME] AS [df], '' AS [df2], '' AS [df3], '' AS [df4] FROM VIEW_USERS WHERE [USERID] IN (N'myuserid') ORDER BY [USEREMAIL] ASC

image
image513×271 9.04 KB

Just for testing, I checked all the permission but it still doesn’t show the Display Field value in List Page of my module.

image
image1256×113 1.84 KB

2

If you enable User ID Security and your users table is protected by User ID field, when you login as a normal user, the User ID Security still works, you only see data owned by you.

As the docs says:

Even you enable all permissions for a user-defined User Level, the User Level will NOT become the same as the Administrator User Level.

3

Thanks. After some reading, I checked on the “Allow View All” option for my USERS table. This way, I can grant “Lookup” permission and able to display properly now.

image