post by NOLO on Oct 29, 2025
post by johnny on Oct 30, 2025
Hello @NOLO ,
Can you please give a bit more information about the field? Is that autogenerated from the date field type or you are adding explicitly a field type date?
Regards
Johnny
post by NOLO on Oct 30, 2025
This is my table
CREATE TABLE IF NOT EXISTS public.encuesta
(
encuesta_id integer NOT NULL DEFAULT nextval(‘encuesta_encuesta_id_seq’::regclass),
tipo_encuesta_id integer,
subtipo_encuesta_id integer,
cobertura_id integer,
levantamiento_id integer,
confianza_error_id integer,
tecnica_id integer,
diseno_muestra_id integer,
nota_tecnica text COLLATE pg_catalog.“default”,
puntos numeric(8,0),
cuestionarios numeric(10,0),
fecha_inicio date,
fecha_fin date,
responsable_id integer,
origen_id integer,
usuario integer,
entidad_id integer,
control_id integer);
$crud->setTable('encuesta');
$crud->FieldType('fecha_inicio','native_date');
$crud->FieldType('fecha_fin','native_date');
My date format is D/M/Y
post by johnny on Oct 31, 2025
Hello @NOLO ,
I can reproduce the issue locally. For now please use this work-around till this is fixed (I will keep you up to date on that):
if ($crud->getState() === 'Datagrid') {
$crud->fieldTypeSearchColumn('fecha_inicio', 'date');
$crud->fieldTypeSearchColumn('fecha_fin', 'date');
}
post by johnny on Nov 1, 2025
Hello @NOLO ,
I am glad to inform you that this is now fixed on latest version 3.2.5 . It was a small fix so I haven’t include it on change logs. You can also enjoy our brand new function setCustomQuery but please keep in mind that currently it is not supporting sorting and search:
Let me know if this fixed the problem and also keep me up to date if there are any issues with the customQuery function 
post by NOLO on Nov 1, 2025
post by johnny on Nov 1, 2025
Thank you @NOLO ,
Keep in mind that search and ordering won’t work and I understand that this is maybe a deal-breaker for many people. On the other hand I am trying to make custom models to be easier to create for complicated queries. I would say setCustomQuery will mostly used on some reports (e.g. summaries… e.t.c.)
post by NOLO on Nov 1, 2025
Works perfectly with postgreSQL views 
New & Unread Topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Using `unsetPagination()` but limit is still applied |
|
3 | 619 | Apr 12 |
| [RESOLVED] Error in “validate.php” in the “_get_language_mapping()” function |
|
10 | 1.9k | Mar 31 |
| [RESOLVED] Updated Grocery CRUD Enterprise from 3.2.4 to 3.2.7 |
|
1 | 842 | Jan 14 |
| The “uniqueFields” function only throws an error in English |
|
0 | 847 | Jan 19 |
| Custom validation functions |
|
0 | 727 | Jan 22 |