topic Create a decimal field in Nuxeo Forum

Create a decimal field

delphine_ — Tue, 18 Dec 2012 12:20:55 GMT

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

Re: Create a decimal field

Anahide_Tchertc — Thu, 20 Dec 2012 11:55:16 GMT

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?

Re: Create a decimal field

delphine_ — Thu, 20 Dec 2012 16:05:30 GMT

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

Re: Create a decimal field

Anahide_Tchertc — Thu, 20 Dec 2012 16:21:34 GMT

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)

Re: Create a decimal field

delphine_ — Fri, 21 Dec 2012 16:44:24 GMT

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