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