[cletourneau]

grocery-crud-enterprise version : 2.5.7

php version : 5.6

database : postgres 9.6

 

When trying to quick filter integer columns, I get this error

Message: pg_query(): Query failed: ERROR: operator does not exist: integer ~~ unknown LINE 1: ...ompanies" WHERE ipsum_finance_companies.id_acomba LIKE '%35%... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

The problems seems to have its source from Grocery-Crud-Enterprise Model.php. All columns seems to be considered as varchar (no matter the column type)

See Model.php _setWhereArray

 

Hope you can fix!

 

 

 

[larasmith]

Could you show your table structure?

 

Mine is working properly...

[cletourneau]

CREATE TABLE public.finance_companies
(
    id_acomba INT PRIMARY KEY,
    no_accreditation INT,
    nom_entreprise VARCHAR(255),
    no_rbq VARCHAR(10),
    adresse VARCHAR(255),
    ville VARCHAR(255),
    code_postal VARCHAR(7)
);

Quick search won't work for all INT columns.

 

Keep in mind my database is Postgres, and I'm using the latest GCE.

[larasmith]

Oh sorry I am not using Postgres as database...