Dashboard Filter - Persons Name Filter only searchable on first name

1

Hi

I have enabled a filter on a column that contains first name and second name on a metabase graph , when you start typing it brings a list of people with there first name.

What is the best way to filter on both first name and second name ?

Thanks

2

Hi @dazzer78
Metabase does not do a “contains” search - it only searches with “starts with” - this is because of how databases and indexing is done, since using “contains” on a table can be very heavy on the database depending on the data size.
You can create your own “contains” - have a look here:
https://www.metabase.com/blog/search-widget/index.html#add-a-search-widget-to-your-sql-question