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 table sorting. 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.
That is odd that Sort tool bar is able to filter the values as numbers correctly but that the filters tool bar is treating the values as text
If you could export the app as JSON with some dummy data so I can confirm the query/transformer are working as needed I can check out the table's date in the state to see what could be done to fix this and get filtering parity.
To export the app with data, you'll need to click on the export button from the debug panel. Then you can attach that file in a comment here for me to download and test
I tested out the Filter tool bar action and it seems that even when there is a hard-coded number being passed in, it is missing those operators for dynamic columns (< > =) and those are only accessible for columns that are non-dynamic and set as numbers.
I can make a feature request for this
For the Sort toolbar option, it appears that both hard coded numbers and strings being converted to numbers via Format do have an ASC/DES arrow option so I am a little confused by why that isn't appearing in your first screenshot
What occurs when you click on one of the options from the Sort dropdown in your screenshot? Are you on the cloud or self hosted?
Also curious about your use case for Dynamic Columns We usually advise against using them unless absolutely necessary for a work around as they are not as robust as normal columns.
Does Format: Auto for the dynamic columns not work for your use case?
If you mouse over the ternary operator in the FX tab it should give you a code preview of what it is evaluating to. Just want to have you double check that the ternary behavior is working as expected for casting the right types
We usually advise against using them unless absolutely necessary for a work around as they are not as robust as normal columns.