Since: 2.0
total_found
Fetch the total amount of rows found by the last call to find(), regardless of the ‘limit’ parameter set. This is different than the total number of rows limited by the current call, which you can get with total().
Function Definition
Returns
(int) Number of rows returned by find(), regardless of the 'limit' parameter
It seems it don’t work when use a “join” option in the find() params
array (
'orderby' => 'created desc',
'join' => 'LEFT OUTER JOIN jomiz_pods_jomiz_dms_data_pods_messages on (jomiz_pods_jomiz_dms_data_pods_messages.record_id = t.id AND jomiz_pods_jomiz_dms_data_pods_messages.pod_name = \'loan\') LEFT OUTER JOIN jomiz_pods_jomiz_dms_available_messages ON (jomiz_pods_jomiz_dms_available_messages.message_code = jomiz_pods_jomiz_dms_data_pods_messages.name )',
'select' => ' `t`.*, GROUP_CONCAT(DISTINCT jomiz_pods_jomiz_dms_available_messages.name ORDER BY jomiz_pods_jomiz_dms_data_pods_messages.created DESC SEPARATOR \'|\' ) as Message_TEXTS',
'groupby' => 't.id',
'offset' => 0,
'limit' => 15,
)