How to search in array in mongodb in questions

Hi, i have a metabase question table.
The document in mongo looks like:

   categories: [ "sport", "vehicle", "real estate" ]

is there a way to filter according to this field by having a dropdown that will show me all the unique values and once i pick it, it will:

  categories: { 
     $in: [
       "select value1", 
       "selected value 2" 

Hi! Metabase still doesn't support arrays :frowning:

1 Like