Category: CRM and lead management

CRM Shows 180 Leads but Only 120 on the List

Read this guide in Polish

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.