Reference Lists and ACLs on table....

[ctu1]

Hi,

I have a reference field on a form and I can open the reference list using the magnifying glass icon. The referenced table has ACLs restricing which records (the read restriction is on the whole row, not the fields or "*") the user can see. So, the user opens the list and it has e.g. 90 records of which the user can see 15. The list displays in batches of 20 records (we want to keep it that way) . So, on the first page the user sees 2 records he can choose and a message that says 18 records removed due to security restraints. The rest of his choices may appear on page 3 or 4. This only goes away when the user sorts the list by clicking on a column header to sort.

Is there a way to make this more user friedly, e.g. sort the list by default (or any other idea welcome) when it is opened? I know the type ahead works but that is not what I am looking for. Its kind of confusing to our users that they see an empty list and e.g. need to page twice to see what they can choose...

Thanx for any feedback,
CT 🙂

[Mark Stanger]

This is the major limitation of the ACL setup. Unfortunately there's really not a way to get rid of the problem you describe by using ACLs. ACLs just don't work very good for row-level read restrictions unless you are restricting access to an entire table.

The best method for row-level read restrictions (where you need to only restrict portions of the records in a table for certain users) is to use a 'Before Query' business rule in place of the ACL. You can check out this article for details.

http://www.servicenowguru.com/scripting/business-rules-scripting/controlling-record-access-before-query-business-rules/

[solonxu]

Hi, I am having the same problem, did you figure out how to fix this? Thanks.