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
Hi dikshag ,
Like Stefan mentioned, Appian would automatically format the value for viewing but the actual value wouldn't change.
If you would like to display the exact value on UI, you could use functions like "fixed"
If you are doing some calculations, you could also refer the below