Forum OpenACS Q&A: Re: .LRN Search thoughts and architecture - Please give feedback

One note on displaying items. You should use listbuilder and make use of pagination where the user already has the option to change the number of objects displayed.

Furthermore, you should add the permission check to the pagination query.

Last but not least, I thought that acs_permission__perission_p was deprecated and we should use

and exists (select 1 from acs_object_party_privilege_map ppm
where ppm.object_id = :project_id
and ppm.privilege = 'read'
and ppm.party_id = :user_id)

instead.