It appears that the page limit setting in CC5 does not do anything. Regardless of what I change it to I always get a max of 30 rows.
[attachment=0]pagelimit.JPG[/attachment]
[attachment=0]pagelimit.JPG[/attachment]
Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `wrdsw_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `wrdsw_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'CCT_Tracker_Mentor' AND `Connection`.`published` = '1'
[2] => DESCRIBE `wrdsw_cf_CCT_CCTRequirements`
[3] => DESCRIBE `wrdsw_cf_CCT_CCTSubmissions`
[4] => SELECT COUNT(`rq`.`req_id`) AS `rq.count` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq` LEFT JOIN `wrdsw_cf_CCT_CCTSubmissions` AS `s` ON `s`.`req_id` = `rq`.`req_id` AND `s`.`user_id` = 1107 WHERE `rq`.`classtype` = 'CCT-0' GROUP BY `rq`.`req_id`
[5] => SELECT `rq`.`req_id` AS `rq.req_id`, `rq`.`item` AS `rq.item`, `rq`.`type` AS `rq.type`, `rq`.`duewk` AS `rq.duewk`, `rq`.`viewlink` AS `rq.viewlink`, `rq`.`submitlink` AS `rq.submitlink`, `rq`.`status` AS `rq.status`, `s`.`datesubmitted` AS `s.datesubmitted`, `s`.`sub_id` AS `s.sub_id`, `s`.`report` AS `s.report`, `s`.`itemsubmitted` AS `s.itemsubmitted` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq` LEFT JOIN `wrdsw_cf_CCT_CCTSubmissions` AS `s` ON `s`.`req_id` = `rq`.`req_id` AND `s`.`user_id` = 1107
WHERE `rq`.`classtype` = 'CCT-0' GROUP BY `rq`.`req_id` ORDER BY `rq`.`duewk` ASC, `s`.`datesubmitted` DESC
LIMIT 30
)
