CRM Shows 180 Leads but Only 120 on the List
The panel header and the paged table give different number of contacts.
How to identify the source of the problem
Check whether COUNT and SELECT use the same RLS filters, statuses, archive and dates.
Compare record ID, current filters, roles and database query result with panel view.
Repair steps
Unify the terms of both queries and explicitly call the total number and number in the current filter.
How to Test Solution
The counter agrees with the list for the active filter, and generally fails to manage the current result.
Security and restrictions
Run tests on anonymized data and control server side permissions, not just on the interface.