Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026988Openbravo ERPA. Platformpublic2014-07-01 17:192014-08-27 12:37
Reporterrafademiguel 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q4Fixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Torafademiguel
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026988: Whereclauses does not work properly on a field with Tree Reference
DescriptionIn Window: "Reference", Tab: "Tree Reference" there are two fields called "HQL/SQL Where clause" and "HQL Where Clause for Root Nodes".

If you use Dynamic Expression like @Characteristic.id@ doesn't work.
Steps To Reproduce- Create a column
- Create a Tree Reference using a Dynamic Expression in the HQL Where Clause (for example "e.characteristic.id = @Characteristic.id@"
- Assign the new reference to the column
- Create a field associated to the column
- Enter into the window
- See that the Reference is not applying the whereclause properly.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? issue26988.export (8,984) 2014-07-17 14:00
https://issues.openbravo.com/file_download.php?file_id=7062&type=bug
? testIssue26988.export (7,500) 2014-07-17 14:01
https://issues.openbravo.com/file_download.php?file_id=7063&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-07-01 17:19rafademiguelNew Issue
2014-07-01 17:19rafademiguelAssigned To => AugustoMauch
2014-07-01 17:19rafademiguelModules => Core
2014-07-01 17:19rafademiguelTriggers an Emergency Pack => No
2014-07-01 17:20rafademiguelReview Assigned To => rafademiguel
2014-07-01 17:48jsetuainIssue Monitored: jsetuain
2014-07-15 13:47rafademiguelSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6049#r6049
2014-07-17 14:00AugustoMauchFile Added: issue26988.export
2014-07-17 14:01AugustoMauchFile Added: testIssue26988.export
2014-08-22 10:04hgbotCheckin
2014-08-22 10:04hgbotNote Added: 0069600
2014-08-22 10:04hgbotStatusnew => resolved
2014-08-22 10:04hgbotResolutionopen => fixed
2014-08-22 10:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b368521a3d6de5a5ba2f2537444fb2bd077c1a2d [^]
2014-08-23 16:30hudsonbotCheckin
2014-08-23 16:30hudsonbotNote Added: 0069642
2014-08-27 12:37rafademiguelStatusresolved => closed
2014-08-27 12:37rafademiguelFixed in Version => 3.0PR14Q4

Notes
(0069600)
hgbot   
2014-08-22 10:04   
Repository: erp/devel/pi
Changeset: b368521a3d6de5a5ba2f2537444fb2bd077c1a2d
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Jul 17 13:58:34 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b368521a3d6de5a5ba2f2537444fb2bd077c1a2d [^]

Fixes issue 26988: Whereclauses do not work on a field with Tree Reference

The context info was not being sent to the datasource in the request.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-tree.js
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/TreeDatasourceService.java
---
(0069642)
hudsonbot   
2014-08-23 16:30   
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/81b875753850 [^]
Maturity status: Test