Error filtering date column with PostgreSQL

1

Hi

When filtering dates in the column header, an error occurs, when debugging SQL the query is done with ilke

date
date233×836 28.1 KB

debug
debug1355×123 54.8 KB

2

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

3

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
4

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');
}
1 Like
5

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 :wink:

1 Like
6

Thanks Johnny!

cees
cees1190×832 131 KB

I will test this feature, since I have been using views, which have the id field as their “primary key,” always the id field. They have been very useful to me since the setPrimarykey function does not work in views.

7

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.)

1 Like
8

Works perfectly with postgreSQL views :smiley:

1 Like