Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027973Openbravo ERPA. Platformpublic2014-10-23 18:342014-12-30 23:26
Reporterjecharri 
Assigned Toinigosanchez 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket31129
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027973: Tree mode does not work if you insert session parameters in the tab HQL Where Clause
DescriptionTree mode does not work if you insert session parameters in the tab HQL Where Clause
Steps To Reproduce-Login as system
-Go to "windows,tab and fields"
-Select window "Organization"
-In the header tab add where clause
e.createdBy.id = @#AD_User_ID@

-Login to ERP as admin
-Go to organization window
-Verify that you can see data. If not go to "initial organization setup" process and create a generic org.
-verify that after that you are able to see the create organization
-press in "tree mode" and verify that no data is loaded
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-23 18:34jecharriNew Issue
2014-10-23 18:34jecharriAssigned To => AugustoMauch
2014-10-23 18:34jecharriOBNetwork customer => Yes
2014-10-23 18:34jecharriModules => Core
2014-10-23 18:34jecharriSupport ticket => 31129
2014-10-23 18:34jecharriResolution time => 1418166000
2014-10-23 18:34jecharriTriggers an Emergency Pack => No
2014-10-24 20:13jecharriResolution time1418166000 => 1416265200
2014-10-27 11:35AugustoMauchTarget Version => 3.0PR15Q1
2014-11-04 16:16alostaleAssigned ToAugustoMauch => inigosanchez
2014-11-19 10:49inigosanchezIssue Monitored: AugustoMauch
2014-11-19 10:49inigosanchezReview Assigned To => AugustoMauch
2014-11-19 10:49inigosanchezResolutionopen => fixed
2014-11-19 10:50hgbotCheckin
2014-11-19 10:50hgbotNote Added: 0071802
2014-11-19 16:31inigosanchezStatusnew => scheduled
2014-11-20 10:10AugustoMauchStatusscheduled => resolved
2014-11-20 10:10AugustoMauchFixed in SCM revision => 441ceb36bd06be50e4f207d3703a906df8ad58b1
2014-11-20 10:12AugustoMauchStatusresolved => new
2014-11-20 10:12AugustoMauchResolutionfixed => open
2014-11-20 10:12AugustoMauchStatusnew => scheduled
2014-11-20 10:12AugustoMauchfix_in_branch => pi
2014-11-20 10:12AugustoMauchStatusscheduled => resolved
2014-11-20 10:12AugustoMauchFixed in SCM revision441ceb36bd06be50e4f207d3703a906df8ad58b1 => https://code.openbravo.com/erp/devel/pi/rev/441ceb36bd06be50e4f207d3703a906df8ad58b1 [^]
2014-11-20 10:12AugustoMauchResolutionopen => fixed
2014-11-24 16:49AugustoMauchNote Added: 0071951
2014-11-24 16:49AugustoMauchStatusresolved => closed
2014-11-24 16:49AugustoMauchFixed in Version => 3.0PR15Q1
2014-11-25 12:09hgbotCheckin
2014-11-25 12:09hgbotNote Added: 0071970
2014-12-30 23:25hudsonbotCheckin
2014-12-30 23:25hudsonbotNote Added: 0073084
2014-12-30 23:26hudsonbotCheckin
2014-12-30 23:26hudsonbotNote Added: 0073134

Notes
(0071802)
hgbot   
2014-11-19 10:50   
Repository: erp/devel/pi
Changeset: 441ceb36bd06be50e4f207d3703a906df8ad58b1
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Wed Nov 19 10:47:55 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/441ceb36bd06be50e4f207d3703a906df8ad58b1 [^]

Fix bug 27973:Tree mode does not work with session parameters in HQLWhereClause

Tree mode does not work if you insert session parameters in the tab HQL Where Clause. For example,
If it is inserted "e.createdBy.id = @#AD_User_ID@" in HQL Where Clause, the HQL Query can not substitute
the parameter #AD_User_ID that is a session parameter. The where clause will be " e.createdBy.id = 'null' ".

Now, substituteParameters() method can search session parameters and substitute them.

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/TreeDatasourceService.java
---
(0071951)
AugustoMauch   
2014-11-24 16:49   
Code reviewed and verified in pi@441ceb36bd06
(0071970)
hgbot   
2014-11-25 12:09   
Repository: erp/devel/pi
Changeset: 2f6b08e9f45d47079733a1ee5deb388d19ae082b
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Nov 24 16:41:13 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2f6b08e9f45d47079733a1ee5deb388d19ae082b [^]

Related with issue 27973: Fixes typo from comments

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/TreeDatasourceService.java
---
(0073084)
hudsonbot   
2014-12-30 23:25   
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/6525fe229e06 [^]
Maturity status: Test
(0073134)
hudsonbot   
2014-12-30 23:26   
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/6525fe229e06 [^]
Maturity status: Test