Can't get column recognition to work if a insert a SQL query in a view's SQL field and refer to tables or views in other schemas. E.g.: If a insert this query in a view's SQL field, the columns get recognized automatically -
select id from some_table
- but if I do this, the parser shows an error message:
select id from some_schema.some_table
Even though some_table has "some_schema" set as it's schema.
Is there a way to get this to work or is it simply a bug/only partly implemented feature?
Customer support service by UserEcho