How to Enable Select Dropdown for Relational Field in SQL-Based Chart Filter

Hi everyone,

I have a transactions table that includes a relational field called currency, which links to a currencies collection. I’m using a SQL collection to group the transactions by currency.

The SQL query works fine, and I’m able to display the results in a chart block. However, when I try to add a filter to the chart using the currency field, the input type shows up as a text input instead of a select dropdown.

I want the filter to behave like a typical relational field with a dropdown of available currencies.

Is there any way to achieve this using SQL? Or do I need to handle it differently so that the filter input type becomes a dropdown instead of text?

Any suggestions or workarounds would be appreciated.

* Environment

  • NocoBase version: v1.6.16
  • Database type: PostgreSQL 15
  • OS: Windows

  • Docker: 25.0.3

The select options for SQL tables currently only supports fixed values and does not support fetching data from relation fields.

1 Like