c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #26315
[Bug 789019] Re: unique keys missing
In general, I can support Ferdinands requirements.
In particular, looking at "symbol" as suggested unique identifier of res.currency, I'd like to note that there are many symbols occurring on different currencies, like Dollar.
There, the unique identifier would be the ISO code.
Please compare https://bugs.launchpad.net/bugs/709201 to see how controverse unique identifiers could be handled.
I think there will be, and has to be, a discussion for most models to what _the_ unique identifier actually is.
Main problem I see: this may differ from use case to use case...
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/789019
Title:
unique keys missing
Status in OpenERP Modules (addons):
Confirmed
Bug description:
IMHO many tables should have uniquenes enforced using a column which
is "visible" for the user, because in production envirenment the user
has to identify and choose the correct resource "reading" the name or
similar.
Caveat: trailing blanks names with trailing "look" identical, but are not identical for check of uniqueness
IMHO it does not make sense to store trailing blanks. (in general)
(ASCII-Code 32, UnicodeU+0020.)
I recognize that there might be resources like partners having the
same "official" name and might be distinguish only by address or
similar. In this case name + reference/code must be used.
res.company - name
res.currency - symbol
res.partner - name (+ reference)
res.partner.bank - account or iban
account.period - name
account.tax - name
product_template - name (+code)
....
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/789019/+subscriptions
References