Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012703Openbravo ERPA. Platformpublic2010-03-17 09:192010-04-19 21:12
Reportermtaal 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version2.50MP15 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012703: Possible to have base reference == Y and parent reference set for AD_Reference
DescriptionThe UI/database does not prevent an ad_reference record from having both the base reference and the parent reference set. This can be done by:
- de-selecting the base reference field
- select a parent reference
- select the base reference
- save

Maybe a database trigger should be added to prevent this.

Another possible additional check which may be done is that if other references use a reference as base reference that the base reference may not be set back to unchecked.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-17 09:19mtaalNew Issue
2010-03-17 09:19mtaalAssigned To => alostale
2010-03-17 09:19mtaalOBNetwork customer => No
2010-03-22 08:30alostaleStatusnew => scheduled
2010-03-22 08:30alostalefix_in_branch => pi
2010-04-07 15:46alostalefix_in_branchpi =>
2010-04-07 15:46alostaleSummaryPossible to have base reference == N and parent reference set for AD_Reference => Possible to have base reference == Y and parent reference set for AD_Reference
2010-04-07 16:20hgbotCheckin
2010-04-07 16:20hgbotNote Added: 0025949
2010-04-07 16:20hgbotStatusscheduled => resolved
2010-04-07 16:20hgbotResolutionopen => fixed
2010-04-07 16:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/74935d22e705145db903d5b046d53b09b4a94b1b [^]
2010-04-15 09:55mtaalNote Added: 0026222
2010-04-15 09:55mtaalStatusresolved => closed
2010-04-15 09:55mtaalFixed in Version => 2.50MP15
2010-04-16 00:00anonymoussf_bug_id0 => 2987967
2010-04-19 21:12hudsonbotCheckin
2010-04-19 21:12hudsonbotNote Added: 0026431

Notes
(0025949)
hgbot   
2010-04-07 16:20   
Repository: erp/devel/pi
Changeset: 74935d22e705145db903d5b046d53b09b4a94b1b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 07 16:32:31 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/74935d22e705145db903d5b046d53b09b4a94b1b [^]

fixed issue 12703: Possible to have base reference == Y with parent
  The fix includes:
    -Trigger to force parent to null for base references
    -WADValidation to ensure no base references with parent

---
M src-db/database/model/triggers/AD_REFERENCE_MOD_TRG.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
---
(0026222)
mtaal   
2010-04-15 09:55   
Checked
(0026431)
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/74935d22e705 [^]
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 [^]