Can't access user table records in reference field

[Rick Forristall]

I Created a table with a reference field to the sys_user table. when I'm in the form and click on that field's magnifying glass I can see all the users if I'm logged in as an admin but when I impersonate a normal user I can't see any records.

I Searched for and read about ACLs but I don't see one on the sys_user table that would prevent users from seeing those records.

I Would appreciate someone pointing me in the right direction.

Thanks,

Rick Forristall

Programmer Analyst

Goodwill of Central Arizona

[Slava Savitsky]

If ACLs do not seem to be the cause of the issue, check if there is a "before query" business rule on Users table that could prevent users from seeing other users' data.

[Rick Forristall]

Slava,

Thank you for your reply.

I looked at all the business rules for the sys_user table with "before" in the When to Run field but am not sure any of those would prevent users from seeing other users' data. Is there something I should look for?

Thanks

Rick Forristall

Programmer Analyst

Goodwill of Central AZ

[Slava Savitsky]

Look for any business rules that match the following conditions:

Table: Users [sys_user]

When: before

Query: true

Such rules can restrict queries based on user's role. For example, the following script in a before query business rule would prevent non-admin users from seeing inactive records:

if (!gs.hasRole("admin"))

       current.addQuery("active", "true");