How to show all records without using pagenation

[Jay N]

Hi Experts,

We have a requirement to fetch list of records which belong to the user, we have used ACL to fetch particular role based records to users. While using this ACL all records are not showing up on the instead its giving option to use pagenation to see other records in next page.

How to fetch all records without using pagenation

Thanks, Jay

[Shivalika]

Hello @Jay N 

The number of records that is shown on a single page is not concerned with ACL. It is modified by user preferences "ROWCOUNT". 

Refer the attached image - 

 Kindly mark my answer as helpful and accept solution if it helped you in anyway,

,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Jay N]

Hi Shivlika,

Thanks for quick response, when we used query bussiness rule, we were able to view limited records with row count as mentioned below. How to show the same record count when using ACL, is it possible.

Thanks, Jay

[Shivalika]

Hello @Jay N 

Yes, it is possible with  READ ACL as well. You need to pass the same script you have passed in business rule. And in the roles tab you cns give specific roles. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

[Simon Christens]

You need to use a combination of ACL and Query business rule to remove the records that the user cannot see.

Query BR is just a predefined filter - but theres no security related to this.

ACLs is a gateway that either allows or denies users from seeing records.

This means that you make you ACLs to deny / allow users to see records
Then create a Query BR that supports the ACLs - filtering away the records that the same user is not allowed to see - this way the users doesnt get "x amount of records removed duo to security constrains" but displays a full list of the records that the user can see.