© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•5mo ago•
1 reply
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%))
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
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.
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Searchable select returning invalid results
FilamentFFilament / ❓┊help
17mo ago
Searchable Select limits results
FilamentFFilament / ❓┊help
3y ago
Custom Searchable Query
FilamentFFilament / ❓┊help
3y ago