table record list problem when using ACL read control

[wai]

Hi Expert,

I have a problem when using ACL limited the records return to user for a table.

For example I have total 158 records, I would like to show to user where field "type" = "A". I achieve this by using ACL set to the table.none level. However when displaying the result, 20 records per page. I found the first several pages with empty records and at the bottom "Number of reos removed from this list by Security constraints..". We need to page next to some which show those records.

Would like to know is there any setting to make this presentation better? E.g. after the ACL there should be 30 records only, I will like to show those 30 records rather than 158 with many empty pages.

Thanks for your support and comment.

Wai

[snehabinani26 · Accepted solution]

The only time you'll see this message is when you're using a row-level read ACL for a table.   Unfortunately there's no way around it using ACLs.   The standard practice for securing a mixed bag of records for a table is to use a 'Before query' business rule instead.   A good example of this in the OOB setup that you can follow is the 'incident query' business rule.   I've written about this at SNGuru so you should find a good explanation here.

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

[dhirajwakodikar]

Hi Sneha,

I am trying to do something similar however the number of sys_ids returned in the before query business are almost 1000+ and due to this the URL becomes too long and the form never loads.

What's the solution for this ?

Any suggestions please.

Kind Regards,

Dhiraj

[Ankur Bawiskar]

Hi Wai,

This is a known issue where records which needs to be shown are split over multiple pages. So user has to scroll till the end to verify whether there are still more records or not.

One thing you can do is use onQuery business rule which may show the records in clubbed manner and user will have to scroll very less to the right.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[snehabinani26]

If your question is answered , please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.