Hi everyone. I added a new Decimal field to one of my DB tables, but when I try to map this source field to the corresponding record field in Appian the Number (Decimal) type is not available in the dropdown (please see the screenshot below). Does anyone know what could be the reason for that? Even Appian recognizes the source field as Decimal, but still doesn't give me a proper option in the choice list. I would appreciate any advice on this matter. Thank you.
Discussion posts and replies are publicly visible
You need to use the "double" datatype instead of decimal, only then will the record identify it as a Number (Decimal) field type.
Alter query for your reference:
ALTER TABLE `TEST_TABLE` CHANGE `test` `test` DOUBLE(50,0) NULL DEFAULT NULL;
hi bohdanmandych You can try changing it from decimal to float/ double data typedifference between float and double is
Float
Double
Hi Nilanshu, thank you for your reply, but I actually found a way to assign a DECIMAL column in the DB to a DECIMAL record field in Appian. By specifying the proper scale, DECIMAL(50,3) instead of DECIMAL(50,0), I was able to properly assign values between Appian and the database without issues.
Add Column reference:
ADD COLUMN `test` DECIMAL(50,3) NULL DEFAULT NULL