Limiting field size in V14 onwards

Question

Since V14 the fields size parameter (size=x) is no longer valid on field definitions.
What is the correct way to limit the size of a string field in the database (not the view) so that the length is automatically cropped to 18 characters?
Please note that I need to do this on a related field:
fields.Char(string='CSV Memo', related='ref', store=False)
Originally in V13 I used:
fields.Char(string='CSV Memo', related='ref', store=False, size=18)

Chris Mann · Accepted Answer

Interesting update. I actually tried adding back size attribute to a field in V15 and it works without issue or any warning in the log! I was surprised as I took the advice from an OCA article https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-14.0. [1]
However I can see that even in V16 there are still many uses of the size attribute used on char fields, for example:
https://github.com/odoo/odoo/blob/16.0/addons/l10n_de/models/datev.py [2]
Anyone know if Odoo backtracked on this

Malay Khamar (Serpent Consulting Services Pvt. Ltd.) · Answer

HI Chris Mann,
Second option will be try to add constraints and check length of the char field in its method. You can raise exception for the size exceed.
If you want to automatically crop it to 18 char , then you have to follow the string slicing. But on you case its related field , so might be automatically cropped will not work.
Hope it will help you.

Verknüpfte Beiträge	Antworten	Ansichten
How to display a red * for required fields fields	3 Mai 25	3378
How to display a red * for required fields fields	1 Apr. 25	2406
one2one relational field Gelöst fields	3 Sept. 24	16066
Is there a maximum data size limit for Odoo SaaS clients? size	1 Juli 24	8835
I cannot see custom field in lead form fields	2 Feb. 24	3458

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!