Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041485
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2019-07-30 12:392019-07-30 17:11
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q4
StatusclosedFix in branchFixed in SCM revision207ebeef9c2b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041485: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0041333 closedcollazoandy4 Duplicate values when create new Product characteristics values 

-  Notes
(0113704)
dmiguelez (developer)
2019-07-30 12:40

Attached output from try:
https://ci.openbravo.com/job/try-api/7363/consoleFull [^]
(0113706)
hgbot (developer)
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 (developer)
2019-07-30 17:11

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2019-07-30 12:39 dmiguelez New Issue
2019-07-30 12:39 dmiguelez Assigned To => Triage Finance
2019-07-30 12:39 dmiguelez Modules => Core
2019-07-30 12:39 dmiguelez Triggers an Emergency Pack => No
2019-07-30 12:40 dmiguelez Assigned To Triage Finance => dmiguelez
2019-07-30 12:40 dmiguelez Note Added: 0113704
2019-07-30 12:40 dmiguelez Relationship added related to 0041333
2019-07-30 13:06 hgbot Checkin
2019-07-30 13:06 hgbot Note Added: 0113706
2019-07-30 13:06 hgbot Status new => resolved
2019-07-30 13:06 hgbot Resolution open => fixed
2019-07-30 13:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/207ebeef9c2b3adc591c208020b15fc85495dcdb [^]
2019-07-30 17:11 dmiguelez Review Assigned To => dmiguelez
2019-07-30 17:11 dmiguelez Note Added: 0113718
2019-07-30 17:11 dmiguelez Status resolved => closed
2019-07-30 17:11 dmiguelez Fixed in Version => 3.0PR19Q4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker