These docs are for v20.3.44. Click to read the latest docs for v20.3.186.

Discussions

Ask a Question
Back to All

Casting values in expression builder

Hello

We are currently using some of the MUF_* tables from Meet_master in some Business object expressions, however all of these are defined as Varchar(100), and we would like to be able to cast these to int so we can preform some arithmetic on the values.

Is there a way to cast these columns? We have tried creating a new BO and setting the column the type as integer, and a few different methods in the expression builder but when we go to apply that the column type is always varchar, and we are unable to use them in our equations. I know we can do this with IQA, however it would be easier to do complete this task in the BO as a source table.

Thanks,
Des