Reduce decimal places on attribute - error ODF-0209

[Daniel Perez]

I am seeing that after creating an attribute-number and set a number of decimals, it is no allowed to reduce it anymore (ODF-0209 Number of decimal places cannot be reduced).

This behavior occurs even if attribute has not been used yet or added as a field to views.

 

Is there any workaround to reduce it without deleting and creating a new one?

 

ODF_CUSTOM_ATTRIBUTES.SCALE contains the value set on Clarity but the restriction is not applied from this field.

Where this restriction come from?

 

 

 

 

Also decimals places can't be reduced from the field at properties view (but it can from List view)

 

 

 

Same behavior on v15.1

 

[Jerin Sebastian]

Hi,

This is a DB design and I dont think we can reduce the decimal points even though its not been used. 

 

If this attribute has not been used at all, the option I can think of is to delete the attribute and recreate a new one.. 

 

Thanks,

Jerin

[Daniel Perez]

Workaround: update to db to modify the field "decimals"(ODF_VIEW_ATTRIBUTES.DECIMALS) on properties views and publish views of the object.

Now all the pages/subpages are displaying the number of decimals expected by user