Retrieve decimal value having more than 7 digits after decimal places (from third party database)

Thank you  and agam for your quick replies but the value itself is getting changed. While querying it via query entity from database only, we are not getting the entire value. We are already converting that decimal value into text before displaying it on screen

Hi dikshag

Can you show your interface code how you are showing the value ?

Also, did you use the function "fixed" ?

How are you converting the value to text

No, we haven't used the function fixed. We type cast it to text with CDT. But the concern here is not while converting from decimal to text. It is working fine. The concern is while fetching the data from database itself, we are not getting the entire value.

Well, keep the type as decimal in your CDT.

And, even if your query entity doesn't reflect full value in its result, it should be fine.

And use fixed function when you display it in your interface.

Can you also describe your use case ?

How is the external database connected with Appian, what database is it ?

What do you want to do with the decimal digits?

Is it just for proper display or you need to perform some calculations on top of it?

Well, keep the type as decimal in your CDT.

And, even if your query entity doesn't reflect full value in its result, it should be fine.

And use fixed function when you display it in your interface.

Can you also describe your use case ?

How is the external database connected with Appian, what database is it ?

What do you want to do with the decimal digits?

Is it just for proper display or you need to perform some calculations on top of it?

Thanks for your suggestion, will try it once. External database is connected via data source with Appian.

Regarding our use case, We are displaying those values in a grid and user can also change the value from screen. There's no calculations required on screen.