Forums

When viewing a list of results with 3 dropdown filters it shows only 30 results of the query. This happens from the start. The only way to see all the entries is to delete the code from the dropdown filters adding a pagination and selecting all results in one page. Any suggestions?

In the debug I see LIMIT 30 but I have no idea how to change it. I didn't set any limits to the results. Anyone knows how to clear this limit?

the debug:

Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `w47fa_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 `w47fa_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'ConsultaFichasResidentes' AND `Connection`.`published` = '1'
[2] => SELECT COUNT(`ConsultaFichasResis`.`id`) AS `ConsultaFichasResis.count` FROM `w47fa_chronoengine_chronoforms_datatable_FichadeResidenteDef` AS `ConsultaFichasResis`
[3] => SELECT `ConsultaFichasResis`.`id` AS `ConsultaFichasResis.id`, `ConsultaFichasResis`.`uniq_id` AS `ConsultaFichasResis.uniq_id`, `ConsultaFichasResis`.`user_id` AS `ConsultaFichasResis.user_id`, `ConsultaFichasResis`.`created` AS `ConsultaFichasResis.created`, `ConsultaFichasResis`.`modified` AS `ConsultaFichasResis.modified`, `ConsultaFichasResis`.`promocion` AS `ConsultaFichasResis.promocion`, `ConsultaFichasResis`.`Especialidad` AS `ConsultaFichasResis.Especialidad`, `ConsultaFichasResis`.`SubirFoto` AS `ConsultaFichasResis.SubirFoto`, `ConsultaFichasResis`.`Nombre` AS `ConsultaFichasResis.Nombre`, `ConsultaFichasResis`.`PrimerApellido` AS `ConsultaFichasResis.PrimerApellido`, `ConsultaFichasResis`.`SegundoApellido` AS `ConsultaFichasResis.SegundoApellido`, `ConsultaFichasResis`.`correo` AS `ConsultaFichasResis.correo`, `ConsultaFichasResis`.`tieneespecialidad` AS `ConsultaFichasResis.tieneespecialidad`, `ConsultaFichasResis`.`EspecialidadPrevia` AS `ConsultaFichasResis.EspecialidadPrevia`, `ConsultaFichasResis`.`especialidadpreviainacabada` AS `ConsultaFichasResis.especialidadpreviainacabada`, `ConsultaFichasResis`.`anoderesidencia` AS `ConsultaFichasResis.anoderesidencia`, `ConsultaFichasResis`.`observaciones` AS `ConsultaFichasResis.observaciones`, `ConsultaFichasResis`.`confidencialidad` AS `ConsultaFichasResis.confidencialidad`, `ConsultaFichasResis`.`Enviar` AS `ConsultaFichasResis.Enviar` FROM `w47fa_chronoengine_chronoforms_datatable_FichadeResidenteDef` AS `ConsultaFichasResis` LIMIT 30
)