← Back to team overview

c2c-oerpscenario team mailing list archive

[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