I have a situation where the data I want to filter by (and that I’m pulling) is all coming from a linked server. I’m able to successfully use the linked server by using fully qualified schema strings but I’m not able to get to the linked server for a field filter b/c the field filters require that you select from the schema in the current database.
For example, I’d like my dropdown to display several different task statuses. This simple query displays the list I’d like to filter with.
SELECT DISTINCT TaskStatus
Is there any way to accomplish this using metabase?