Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012470Openbravo ERP00. Application dictionarypublic2010-02-25 12:592010-05-18 12:12
networkb 
alostale 
highminoralways
closedfixed 
5
2.50MP11 
2.50MP172.50MP15 
Core
No
0012470: The application dictionary allows to check two columns as "iskey" what is not correct
The application dictionary allows to check two columns as "iskey" what is not correct. You should get an error because if you try to access to the window related with this table after check two columns as iskey withoug compile,
you can not access to the edit view.
-Login as system administrator
-Go to the c_invoiceline definition table on the application dictionary
-Check the column line as "iskey"
-Save and login as Openbravo admin
-Go to sales invoice window and to the lines tab
-Try to see the window in edition view. It is not possible.

No tags attached.
Issue History
2010-02-25 12:59networkbNew Issue
2010-02-25 12:59networkbAssigned To => alostale
2010-03-01 08:51alostaleStatusnew => scheduled
2010-03-01 08:51alostalefix_in_branch => pi
2010-03-08 16:05jpabloaeTarget Version2.50MP14 => 2.50MP15
2010-04-07 09:54hgbotCheckin
2010-04-07 09:54hgbotNote Added: 0025924
2010-04-07 09:54hgbotStatusscheduled => resolved
2010-04-07 09:54hgbotResolutionopen => fixed
2010-04-07 09:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3b09034cc725f849c0f67a8328d473d93aaa92db [^]
2010-04-12 17:59marvintmNote Added: 0026074
2010-04-12 17:59marvintmStatusresolved => closed
2010-04-12 17:59marvintmFixed in Version => 2.50MP15
2010-04-13 00:00anonymoussf_bug_id0 => 2986150
2010-04-19 21:12hudsonbotCheckin
2010-04-19 21:12hudsonbotNote Added: 0026426
2010-05-18 12:12gorka_gilTarget Version2.50MP15 => 2.50MP17

Notes
(0025924)
hgbot   
2010-04-07 09:54   
Repository: erp/devel/pi
Changeset: 3b09034cc725f849c0f67a8328d473d93aaa92db
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 07 10:05:35 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3b09034cc725f849c0f67a8328d473d93aaa92db [^]

fixed bug 12470: The application dictionary allows to check two columns as "iskey"
  The fix includes:
    -Callout to prevent multiple key columns: a message is shown and the second key is unchecked
    -WADValidation to validate there are no tables with mulitple key columns

---
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-wad/src/org/openbravo/wad/validation/WADValidationResult.java
M src-wad/src/org/openbravo/wad/validation/WADValidator.java
M src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql
A src/org/openbravo/erpCommon/ad_callouts/SL_Column.java
---
(0026074)
marvintm   
2010-04-12 17:59   
Verified that you can no longer set a second column as key from the application.
(0026426)
hudsonbot   
2010-04-19 21:12   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/3b09034cc725 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]