Hi All,
In third party database, we have a column (number datatype containing decimal values - NUMBER(15,12)) which can have more than 7 digits after decimal place. In database, for example, the value is 33.3333333333
but when we are fetching the data via query entity, it is coming as 33.33333 and not the entire value. Datatype we have used in CDT is Number (Decimal) and xsd type xsd:decimal. We have also tried xsd:double in CDT but the result is same.
Is there any range restriction on Number(Decimal) ?
How to fetch the entire value from database?
Kindly advice.
Thanks and Regards,
Diksha
Discussion posts and replies are publicly visible
Appian does always format the value when displaying it on screen. This formatting includes limiting the number of decimal digits. The value itself will not change.