How to restrict all columns (not column) to specific datatype in the parameter

sth-dss

Hi DSS community,

I am in the process of developing a widget, and one of my parameters needs to be of type "COLUMNS", but restrict ALL data types to only be numeric (["tinyint", "smallint", "int", "bigint", "float", "double"]). I know this is doable for a single column parameter ("COLUMN") by using the argument "allowedColumnTypes", however when I try to do this for my "COLUMNS" param, it only produces the desired warning message for the first column. For any others, it does not return a message, even if a non-numeric is selected.

Does anyone know a way around this?

Thanks in advance,

Sophie

Sarina

Hi @sth-dss
,

Thank you for the question! Your finding is currently correct - the allowedColumnTypes option does not apply to multiple columns when using the type COLUMNS. Instead it indeed will only apply to the first selection. This is noted and currently in our backlog.

Thanks,
Sarina