Offset and count()
Developer Preview
7 years ago
Hi Guys,
I have a weird issue. it seems that count() always return zero when using ->offset().
ee('Model')->get('ChannelEntry')->offset(10)->count(); //return 0
ee('Model')->get('ChannelEntry')->count(); //return correct numberIt seems like an issue with MySQL and not with EE self (https://stackoverflow.com/questions/32814423/mysql-get-count-of-items-after-offset). But it would be nice to fix this.
Any idea how to get around this problem?
7 years ago
I’d probably do something similar to the suggestions there, and keep your logic in PHP if you want. Number of ways to handle it, one might be:
$offset = 10;
$total = ee('Model')->get('ChannelEntry')->count();
$count = ($total - $offset > 0) ? $total - $offset : 0;
7 years ago
Of course… Thanks!