Let the platform do the work

Troubleshooting Incorrect Record Count

Overview

An incorrect count is shown when selecting "All records" as well as in a module's listview count.

Origin

The option "disable_count_query" can be added to config_override.php to prevent sugar from displaying the total number of records for a module in the ListView. This improves performance for many instances, but it also causes the total count to display incorrectly.

Resolution

This is only a cosmetic issue. The All Records option still works as designed despite the incorrect count. In order to see a true count of how many records a module has, click the last page arrow on the top right of the records listing.