Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012470Openbravo ERP00. Application dictionarypublic2010-02-25 12:592010-05-18 12:12
Reporternetworkb 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP17Fixed in Version2.50MP15 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012470: The application dictionary allows to check two columns as "iskey" what is not correct
DescriptionThe 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.
Steps To Reproduce-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.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-25 12:59networkbNew Issue
2010-02-25 12:59networkbAssigned To => alostale
2010-02-25 12:59networkbOBNetwork customer => Yes
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 [^]