Custom Filter using "LIKE"

[Thomas165]

Hey Guys,

I want to use LIKE in a native Query in a Custom Filter.

The Idea is, that a User of the Query doesn't have to know the Complete name of the Customer.

So he should be able to search for "Flex" instead of Writing the Complete Name stored in the Database.

I tried it with standard SQL Syntax in many differend styles, but nothing worked. Than I Found this old Discuss Topic:

Filters on a text variable using LIKE '%%'

I’ve been playing around with filters and tried to filter a text variable to find all elements that matched partially the text input. I tried different variations of ‘[[WHERE text_column LIKE ‘%{{text_variable}}%’ ]]’ but I couldn’t make it work. Is this actually possible (if so, please enlighten me ) or is there a reason why it can’t be done? Thanks

Summary:
like "%"{{referrer}}"%"
LIKE CONCAT(’%’,{{variable}},’%’)
LIKE ‘%’ || {{text_variable}} || ‘%’
LIKE ‘%’||{{variable}}||’%’

I tried them all, they don't work for me. Latest Post is from Nov'19, so it is possible, that it doesn't work anymore like this.

But I where not able to find something in the Docs, maybe somewone of you can Help?

Thx Guys

[flamber]

Hi @Thomas165
Have a look here: https://www.metabase.com/learn/sql-questions/sql-variables.html#basic-input-variable-text