I have a variable that has a type field filter. On mapping it to a field I am trying to select a field from a view that I have created in MySQL table.
I have successfully run the sync and I can see the new view in the data model section.
Let me know if this is an intended behaviour that views are not being listed during field mapping or is there anything else I need to do?
Hi @arpit.goyal
Make sure that the Field Type in Admin > Data Model > (db) > (table) > (column), is one of the accepted ones:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#creating-sql-question-filters-using-field-filter-variables
I have set it to Category which is within the list of accepted ones.
Post "Diagnostic Info" from Admin > Troubleshooting.
Which version of MySQL?
What is the column type in the View?
Please find the diagnostic information here - Metabase - Diagnostic Info - Pastebin.com
I am connecting to an Amazon RDS instance which is running a MariaDB version 10.5.9
The column type is a varchar in the database.
@arpit.goyal Changing types after you have viewed some pages creates browser caches, which are not correctly invalidated until you do a browser refresh. That's a known problem throughout Metabase, which something that we're trying to address.
For reference: https://github.com/metabase/metabase/issues/10330#issuecomment-610900593
having same problem. Log out and log in helped as well. Thanks for help!