Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012777Openbravo ERPZ. Otherspublic2010-03-23 18:112010-12-09 16:00
Reportershuehner 
Assigned Tomtaal 
PrioritylowSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012777: When changing the table of a defined selector, the property path of all existing fields should be validated
DescriptionI.e. if a selector is defined on table A, including the fields with property paths valid for A, then the selector is changed to be based on table B the property paths might be invalid (most likely).

Ideally all those path should be validated against the new table.

Note this can be only done in java in a reasonable amount of time and would need to have fr 7158 implemented first (java level triggers).
Steps To ReproduceSee description
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on feature request 0007158 acknowledged iciordia Data and user interface events (similar to database triggers) 
Not all the children of this issue are yet resolved or closed.
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-23 18:11shuehnerNew Issue
2010-03-23 18:11shuehnerAssigned To => mtaal
2010-03-23 18:11shuehnerRelationship addeddepends on 0007158
2010-03-31 02:50mtaalNote Added: 0025812
2010-03-31 13:09hgbotCheckin
2010-03-31 13:09hgbotNote Added: 0025833
2010-03-31 13:09hgbotStatusnew => resolved
2010-03-31 13:09hgbotResolutionopen => fixed
2010-03-31 13:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/0de98bfd33dad7eac77520681050fc19efbffd84 [^]
2010-04-23 18:40shuehnerNote Added: 0026656
2010-04-23 18:40shuehnerStatusresolved => closed
2010-12-09 16:00anonymoussf_bug_id0 => 3133084

Notes
(0025812)
mtaal   
2010-03-31 02:50   
I will do this differently. If there are selector fields it is not allowed to change the datasource/table of a selector. I will do this in a trigger.
(0025833)
hgbot   
2010-03-31 13:09   
Repository: erp/mods/org.openbravo.userinterface.selector
Changeset: 0de98bfd33dad7eac77520681050fc19efbffd84
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Mar 31 13:19:26 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/0de98bfd33dad7eac77520681050fc19efbffd84 [^]

Updated module dependency, fixes issue 12777: When changing the table of a defined selector, the property path of all existing fields should be validated

---
M src-db/database/model/triggers/OBUISEL_SELECTOR_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0026656)
shuehner   
2010-04-23 18:40   
Tested on latest published module version. to change the table used now one must remove all selector fields before doing so.