Skip to Content

How to change a data type in a graphical calculation view

Nov 22, 2017 at 09:55 AM


avatar image

How do I change the data type of a calculation view?

Background: we do comparison tests with DbUnit. DbUnit requires the data-types to be exactly the same.

So I need to change for example from BigInt to Int.
SQL equivalent: cast(colName as integer)

(I do see the data-type in the properties window of a column. But do not see any option to change it)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Thorsten Watzke
Nov 23, 2017 at 07:34 AM

Hi Thorsten,

I think you only can do this with a (new) calculated column for each field:

Best Regards


1.jpg (17.4 kB)
2.jpg (56.6 kB)
3.jpg (35.5 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

That was my work-around too.

Thanks for sharing that this is the way to go


Looking at the orig. question this actually is what you asked for: the equivalent of the SQL type cast. Just like in SQL one has to explicitly declare the conversion and provide a name for thr projected colum.