nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a decimal field

delphine_

Hello,

I want to create a decimal field for a document. I try "integer" but I can just write an integer ... Then, I try "floating point" but even if I write "35.68", it save "35.0".

How can I do it ?

Thanks in advance for your help

Find more posts tagged with

Accepted answers

Anahide_Tchertc

I just tested, and had no issue. I guess since you started with an "int" type, the database was initialized to store an integer for this field. When changing it to a "floating point" after, i see the following error in logs:

ERROR [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "FILE_SCHEMA"."MYINTOTBEFLOAT": expected 8, database has -5 / BIGINT (19)

So i guess you just need to drop your test database for this to be working as expected (or to alter the database column if you'd like to keep your current data)

All comments

Anahide_Tchertc

When you say "it saves", what do you mean? How are you setting this value? What widget type are you using if you're setting this via a form?

delphine_

In Studio, I creates a document type "XXX" with a field "Floating Point" (my_field).

Anahide_Tchertc

ERROR [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "FILE_SCHEMA"."MYINTOTBEFLOAT": expected 8, database has -5 / BIGINT (19)

So i guess you just need to drop your test database for this to be working as expected (or to alter the database column if you'd like to keep your current data)

delphine_

Thank you very much ! I altered the column and it works !