Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022085Openbravo ERPA. Platformpublic2012-10-24 10:382012-11-06 10:47
ReporterioritzCia 
Assigned ToioritzCia 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.04
Product Version 
Target VersionFixed in Version3.0MP17 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browserGoogle Chrome, Mozilla Firefox
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022085: Error when creating an hql query selector for organization.
DescriptionThere is an error in parseOptionalFilters method of CustomQuerySelectorDatasource.java file.This method around line 176 tries to filter by organizations, for this, it appends '.organization in (...)' to the alias of the query. If the entity of the query is organization this fails because there is no organization.organization field.
Steps To Reproduce- Create an hql selector for organizations. You can follow these steps: http://wiki.openbravo.com/wiki/Selector_Example [^] instead for Business Partner create it for organization. Create it with @additional_filters@ parameter (explained in the wiki document).
- Instead of using search parent reference use OBUISEL_Selector Reference one.
- You can define the selector in an org field. For this you have to change the reference of the field to OBUISEL_Selector Reference and the reference search key to the created selector.
- See that when accessing the tab, it fails because it tries to execute organization.organization.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0036863 closed caristu Custom Query Organization selectors information changes depending on the selected organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-24 10:38ioritzCiaNew Issue
2012-10-24 10:38ioritzCiaAssigned To => ioritzCia
2012-10-24 10:38ioritzCiaWeb browser => Google Chrome, Mozilla Firefox
2012-10-24 10:38ioritzCiaModules => User Interface Selector
2012-11-02 08:48hgbotCheckin
2012-11-02 08:48hgbotNote Added: 0053966
2012-11-02 08:48hgbotStatusnew => resolved
2012-11-02 08:48hgbotResolutionopen => fixed
2012-11-02 08:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b5e2d6ab7ce48f9975130c601b38bf009408eed1 [^]
2012-11-05 16:53AugustoMauchReview Assigned To => AugustoMauch
2012-11-05 16:53AugustoMauchNote Added: 0053997
2012-11-05 16:53AugustoMauchStatusresolved => closed
2012-11-05 16:53AugustoMauchFixed in Version => 3.0MP17
2012-11-06 10:47hudsonbotCheckin
2012-11-06 10:47hudsonbotNote Added: 0054029
2017-09-18 18:59caristuRelationship addedrelated to 0036863

Notes
(0053966)
hgbot   
2012-11-02 08:48   
Repository: erp/devel/pi
Changeset: b5e2d6ab7ce48f9975130c601b38bf009408eed1
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Oct 24 10:39:29 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b5e2d6ab7ce48f9975130c601b38bf009408eed1 [^]

Fixes issue 22085: Error when creating an hql query selector for organization.

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0053997)
AugustoMauch   
2012-11-05 16:53   
Code reviewed and verified in pi@3b7ece7dc2c1
(0054029)
hudsonbot   
2012-11-06 10:47   
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/905762a34c04 [^]

Maturity status: Test