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
)
I solved it, I leave it if it's helpful for someone else.
In Frontlist Settings set in the Page limit the maximum number of results you want to show. It seems that for default the limit is set to 30.
