Set up Kanban View on Postgres Logical View?

External Data Source
1

I have treatment table which column treatment_status I set to “Single Select” type of NocoDB. But when I join into a view table, that column turn to normal text. Therefore, I can’t set up a Kanban View on the view table. How can I handle that to set up kanban view on View table?

2

Hi @layeonchart

I guess you are referring SQL views which we do not support UI types.
As SQL views are just SQL queries on underlying layer there is no way for us to extract types hence it is not possible to use UI types (also we don’t support changing types on UI as well for SQL views).

You can make use of our Links with Lookup & Rollup to create different representations over multiple tables.

1 Like
3

I solved that by not setting up Postgres View table and used NocoDB to view that. Instead, I used Default View of NocoDB and changed type of treatment_status column to Single Select after giving rights to change database schema. Then from treatment table view I set up Foreign Key for NocoDB to detect Links as I want.