Filament•16mo ago

TagsColumn searchable()?

I am trying to use the TagsInput field but in such a way that I can filter or search for records by tag. TagsColumn::make('tags')->separator(',')->searchable() doesn't work - it doesn't search for records with tags. Also, TagsColumn is marked as 'depraced'. I also don't see in the documentation the use of a filter with tags, the only example on Discord I can find is for spatie-tags. So should I use spatie-tags to be able to filter data by tags?

Solution:

try this: ```php TextColumn::make('tags') ->badge() ->separator(',')...

Jump to solution

33 Replies

LeandroFerreira•16mo ago

TextColumn::make('tags')
    ->badge()
    ->separator(',')
    ->searchable()

TextColumn::make('tags')
    ->badge()
    ->separator(',')
    ->searchable()

qcolOP•16mo ago

doesn't work That's the problem: it doesn't work (at least for me).

LeandroFerreira•16mo ago

what is the issue? are the tags showing on the table?

qcolOP•16mo ago

It simply does not search for records. I enter a TAG in the search field and it does not search for records that contain that TAG. Yes, the TAG appears both in the table and works correctly in the form.

LeandroFerreira•16mo ago

weird..what is the filament version?

qcolOP•16mo ago

I have just done an update, the latest v3.0.15, still not working.

qcolOP•16mo ago

depraced?

LeandroFerreira•16mo ago

did you try my code?

qcolOP•16mo ago

Does it work that way for you?

LeandroFerreira•16mo ago

should work as well I have a tag column and it is working here.. it is a json column as well

qcolOP•16mo ago

Oh, sorry. I hadn't noticed that there was a TextColumn in yours. Unfortunately after replacing it still doesn't work. Does it work that way for you? Hmmm... OK, so something is wrong with me. I am therefore looking for the cause. Thank you.

Matthew•16mo ago

@qcol74 Can you try php artisan view:clear? Sometimes its the cache

LeandroFerreira•16mo ago

ok if it doesn't work, share the code

Thijmen•16mo ago

In the old docs it says you need to cast the tags column. Not sure if this is needed on TextColumn

qcolOP•16mo ago

Yes I Have casts

qcolOP•16mo ago

New doc too https://filamentphp.com/docs/3.x/tables/columns/tags

Tags column - Table Builder - Filament

LeandroFerreira•16mo ago

the search should work without it

Matthew•16mo ago

Can you please try this? If not please share the whole class

qcolOP•16mo ago

Unfortunately, it did not help.

Thijmen•16mo ago

Please share your full code and the value from your database

qcolOP•16mo ago

qcolOP•16mo ago

1. phpMyAdmin 2. Filament 3. code

qcolOP•16mo ago

result

Thijmen•16mo ago

What is your cast?

qcolOP•16mo ago

LeandroFerreira•16mo ago

try set "esd" and search for esd (lowercase)

qcolOP•16mo ago

does not work either

Solution

LeandroFerreira•16mo ago

try this:

TextColumn::make('tags')
    ->badge()
    ->separator(',')
    ->searchable(query: function (Builder $query, string $search): Builder {
        $search = Str::upper($search);
        return $query->where('tags', 'like', "%{$search}%");
    })

TextColumn::make('tags')
    ->badge()
    ->separator(',')
    ->searchable(query: function (Builder $query, string $search): Builder {
        $search = Str::upper($search);
        return $query->where('tags', 'like', "%{$search}%");
    })

qcolOP•16mo ago

Yes, i found problem

qcolOP•16mo ago

Filament converts TAG to lower case in the query Yes Leandro... now it works!

qcolOP•16mo ago

Thank you very much for your time. I think it's a bug? I'll report it on github. Your solution, on the other hand, will not work on lowercase tags. This works with any letter size:

 TextColumn::make('tags')
    ->badge()
    ->separator(',')
    ->searchable(query: function (Builder $query, string $search): Builder {
        $search = Str::lower($search);
        return $query->where(DB::Raw('LOWER(tags)'), 'like', "%{$search}%");
    })

LeandroFerreira•16mo ago

yep it was a test actually... you can use ->whereRaw(..) as well

Gaming

Programming

TagsColumn searchable()?