Native SQL filter for NOT IN


#1

How would you go about specifying a text filter that is used in a ‘NOT IN’ filter in Metabase?


#2

I would try a Field filter, if possible, using a NOT() (or anything similar to it in your database) around it.

Other than that, for instance, in MySQL, you could go for functions like FIND_IN_SET, and input your string as a list of items comma-separated. Not ideal, but possible (given your database has some function along those lines).


#3

Related to