F
Filament•2mo ago
Hro

Postgres searchable results in invalid query?

Hi! Just ran into this as I was making some columns searchable. Given: 
        return $table
            ->searchable(['subject'])
            ->columns([...
        return $table
            ->searchable(['subject'])
            ->columns([...
It results in: select count(*) as aggregate from "mail_threads" where ("mail_threads"."deleted_at" is null) and ("""subject""::text"::text like %ontb%)) ERROR: column ""subject"::text" does not exist Not sure as to why, when I make ->searchable on the column it works as expected. The above is a simplified version, I am using "root" level searchable to include nested values as well.
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?