Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041485Openbravo ERP02. Master data managementpublic2019-07-30 12:392019-07-30 17:11
Reporterdmiguelez 
Assigned Todmiguelez 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q4 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041485: API Change Request
DescriptionDo not allow duplicated names in Values of non Variant Product Characteristics.

As of now, for Variant Product Characteristics, it is not possible to have more than one value with the same name for the same Characteristic.
However, it was possible to have duplicated values in non Variant Product Characteristics.
Steps To ReproduceTested in Pi:
1.- Go to the back-end and create a Product characteristic:
    - Org: F&B España - Región Norte
    - Name: Test
    - Variant = N
    - Active = Y

2.- Go to values tab for "Test"
    - Name = Test1
    - SummaryLevel = N
    - Active = Y

3.- Go to the back-end and insert again the same characteristic value
 
It is allowing to have duplicates values
Proposed SolutionMake a unique restriction in the Database of a Product Characteristic and the Name of the value
Additional Information
TagsNo tags attached.
Relationships
related to defect 0041333 closed collazoandy4 Duplicate values when create new Product characteristics values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-07-30 12:39dmiguelezNew Issue
2019-07-30 12:39dmiguelezAssigned To => Triage Finance
2019-07-30 12:39dmiguelezModules => Core
2019-07-30 12:39dmiguelezTriggers an Emergency Pack => No
2019-07-30 12:40dmiguelezAssigned ToTriage Finance => dmiguelez
2019-07-30 12:40dmiguelezNote Added: 0113704
2019-07-30 12:40dmiguelezRelationship addedrelated to 0041333
2019-07-30 13:06hgbotCheckin
2019-07-30 13:06hgbotNote Added: 0113706
2019-07-30 13:06hgbotStatusnew => resolved
2019-07-30 13:06hgbotResolutionopen => fixed
2019-07-30 13:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/207ebeef9c2b3adc591c208020b15fc85495dcdb [^]
2019-07-30 17:11dmiguelezReview Assigned To => dmiguelez
2019-07-30 17:11dmiguelezNote Added: 0113718
2019-07-30 17:11dmiguelezStatusresolved => closed
2019-07-30 17:11dmiguelezFixed in Version => 3.0PR19Q4

Notes
(0113704)
dmiguelez   
2019-07-30 12:40   
Attached output from try:
https://ci.openbravo.com/job/try-api/7363/consoleFull [^]
(0113706)
hgbot   
2019-07-30 13:06   
Repository: erp/devel/api-checks
Changeset: 207ebeef9c2b3adc591c208020b15fc85495dcdb
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 30 12:51:15 2019 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/207ebeef9c2b3adc591c208020b15fc85495dcdb [^]

Fixes Issue 41485. Adds new Database Constraint to the Table.

---
M model/src-db/database/model/tables/M_CH_VALUE.xml
---
(0113718)
dmiguelez   
2019-07-30 17:11   
Code Review + Testing Ok