Yajra Datatables with postgreSQL

Question

I am using yajra datatables in Laravel for a while but I have a problem with search on postgreSQL.

Every time I want to search something I get

SQLSTATE[42601]:Syntax error:7 ERROR zero-length delimited identifier at or near """" LINE 1: name as TEXT))...

I suppose that is because different search query on postgreSQL but don't know where to change that and how to setup correctly

knubbe · Accepted Answer · 2019-11-07 10:43:15Z

1

I found what cause a problem. It's not a package problem with postgreSQL but with eloquent relations that Model::query in datatables don't recognize and can't search. I must edit column where I have a relation data and return it back

answered Nov 7, 2019 at 10:43

knubbe

1,2022 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Yajra Datatables with postgreSQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related