Continuing the discussion from Dynamic columns formatted as number sorting as strings:
Hello! I've run into another bit of weirdness with filters on dynamic columns. I have a handful of dynamic columns on this table. I convert them to Number() in the transformer of the query that retrieves the data, and explicitly cast to number type in the dynamic columns settings for the table. They sort as numbers when using the
However, in the table's filters and sort toolbar, these columns are treated as text, which means no equality or < > filters, which my users would like to be able to use.
Thank you for your help in advance!
Sort toolbar
Filters toolbar
Explicitly casting to number type
