Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0027536Openbravo ERP02. Master data managementpublic2014-09-03 18:232014-12-30 23:22
egoitz 
reinaldoguerra 
urgentmajoralways
closedfixed 
5
3.0PR14Q2.5 
3.0PR15Q1 
vmromanos
Core
No
0027536: When adding a new value to a characteristics, that is added on the product characteristic value also for not generic products.
When adding a new value to a characteristics, that is added on the product characteristic value also for not generic products.
This new value should be added only to the generic products using that characteristic.
-Create a product characteritics: color
-Create a value: red
-Create a generic product and asign the "color" characteristic.
-Execute the create variants process.
-Check on the database that on the m_product_ch_conf table you have only one entry (for the generic product)
-add a new value on the color characteristic: blue
*-Check on the database that on the m_product_ch_conf table you have right now 3 rows.
One for red and the generic product, but the blue value has been inserted for both products, the generic and the created one.
see attached file
No tags attached.
diff checkValueTRG_Final.diff (645) 2014-09-04 16:55
https://issues.openbravo.com/file_download.php?file_id=7214&type=bug
Issue History
2014-09-03 18:23egoitzNew Issue
2014-09-03 18:23egoitzAssigned To => dmiguelez
2014-09-03 18:23egoitzModules => Core
2014-09-03 18:23egoitzTriggers an Emergency Pack => No
2014-09-03 18:29egoitzResolution time => 1413324000
2014-09-03 18:29egoitzAssigned Todmiguelez => jonalegriaesarte
2014-09-03 18:29egoitzTarget Version => 3.0PR14Q4
2014-09-03 18:35egoitzFile Added: checkValueTRG.diff
2014-09-03 18:35egoitzProposed Solution updated
2014-09-04 16:54egoitzFile Deleted: checkValueTRG.diff
2014-09-04 16:55egoitzFile Added: checkValueTRG_Final.diff
2014-09-08 16:12jonalegriaesarteAssigned Tojonalegriaesarte => AtulOpenbravo
2014-09-22 16:36jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-04 00:01reinaldoguerraAssigned ToAtulOpenbravo => reinaldoguerra
2014-10-04 00:01reinaldoguerraStatusnew => scheduled
2014-10-04 08:26reinaldoguerraNote Added: 0070707
2014-10-07 16:50hgbotCheckin
2014-10-07 16:50hgbotNote Added: 0070776
2014-10-07 16:50hgbotStatusscheduled => resolved
2014-10-07 16:50hgbotResolutionopen => fixed
2014-10-07 16:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/082dc529e69254ad57f7334141111d42b51839d8 [^]
2014-10-07 16:51vmromanosReview Assigned To => vmromanos
2014-10-07 16:51vmromanosNote Added: 0070777
2014-10-07 16:51vmromanosStatusresolved => closed
2014-12-30 23:22hudsonbotCheckin
2014-12-30 23:22hudsonbotNote Added: 0072913

Notes
(0070707)
reinaldoguerra   
2014-10-04 08:26   
Test plan used:
1- Login into Openbravo ERP
2- Create a product characteritics: color
3- Create a value: red
4- Create a generic product and asign the "color" characteristic.
5- Execute the create variants process.
6- Check on the database that on the m_product_ch_conf table you have only one entry (for the generic product)
7- Add a new value on the color characteristic: blue
8- Check on the database that on the m_product_ch_conf table you have now 2 rows: both, red and blue, for the generic product.
(0070776)
hgbot   
2014-10-07 16:50   
Repository: erp/devel/pi
Changeset: 082dc529e69254ad57f7334141111d42b51839d8
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Fri Oct 03 21:34:50 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/082dc529e69254ad57f7334141111d42b51839d8 [^]

Fixed bug 27536: Characteristics is added also for not generic products.

Modified trigger when saving characteristic value, to insert in product characteristic configuration only values for generic products.
Also only values of characteristics with variant flag checked are now inserted.

---
M src-db/database/model/triggers/M_CH_VALUE_TRG.xml
---
(0070777)
vmromanos   
2014-10-07 16:51   
Code review + testing OK
(0072913)
hudsonbot   
2014-12-30 23:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^]
Maturity status: Test