Custom filter with numeric values in SQL Source


I’m trying to filter my Data based on custom filters.
The problem: The filter primary ID’s are numbers. Which means that I can’t do “if value contains,” only equals- which would mean results are empty if one of the filters are not selected.

Due to the limitations of SQL Data sources, you can’t filter collections based on computed columns. So I can’t convert the columns in the table to text, to filter based on them.

A workaround of using Database views with columns formatted as text doesn’t work either because when pushing data to the real table, we need to reload the View, resulting in the entire screen reloading- which is not an option.

Any suggestions?

So you’re trying to filter your data based on a number column? Or a computed column?

based on a number column.
a computed column is impossible at the moment in SQL