how to remove the message "Number of rows removed from this list by Security constraints"

[CBunty]

I have a record level ACL which provides   read access to only the assigned groups and people part of assigned groups companies. It is working fine and only assigned groups and the department have read access to incident tickets

When I impersonate the user of a department I only see the tickets created in the department.

When I click on the module Open Incidents list results are spread across different list results. In some cases if the incidents are very new the first list results are empty but if we go through the list it shows in the last page.

I have 219 incident records and 50 incidents qualify for a department A. If   I impersonate the user from department A and click on Open Incidents module I only see 10 results and will have message as "Number of rows removed from this list by Security constraints:15". To see the next set of incidents I have to click on > or >> appearing below the list results. I want all the results to be appearing on the

[touqeer]

Hi CBunty,

I used the code for above link. I configured the code based on my requirement. Only logged in users can see there records. But manager can see all other users records. Everything is working fine, but i am getting a bug. Manager is not able to create records. When I create record i am getting below error.

Thanks,

Uzma

[Simon Christens]

Are you in Jakarta build ?

I have seen the same in an instance just upgraded from Helsinki to Jakarta. - before the upgrade it worked.

At the moment im waiting for HI to respond

The interresting part is that the I icon (preview) shows the fields in the record but when entering the form of the record (No record found) is shown

[touqeer]

Simon,

Solved the issue just added or condition.

Thanks,

Uzma

[Simon Christens]

Hi Uzma

I did solve it as well with rebuilding the query BR.

But it seems that query BR's now also somehow apply upon opening a record and not just the initial table query.