0022085: Error when creating an hql query selector for organization.

Description

There 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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0036863

closed

caristu

Custom Query Organization selectors information changes depending on the selected organization

Notes
(0053966) hgbot (developer) 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 (administrator) 2012-11-05 16:53	Code reviewed and verified in pi@3b7ece7dc2c1

(0054029) hudsonbot (developer) 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

Issue History
Date Modified	Username	Field	Change
2012-10-24 10:38	ioritzCia	New Issue
2012-10-24 10:38	ioritzCia	Assigned To	=> ioritzCia
2012-10-24 10:38	ioritzCia	Web browser	=> Google Chrome, Mozilla Firefox
2012-10-24 10:38	ioritzCia	Modules	=> User Interface Selector
2012-11-02 08:48	hgbot	Checkin
2012-11-02 08:48	hgbot	Note Added: 0053966
2012-11-02 08:48	hgbot	Status	new => resolved
2012-11-02 08:48	hgbot	Resolution	open => fixed
2012-11-02 08:48	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/b5e2d6ab7ce48f9975130c601b38bf009408eed1 [^]
2012-11-05 16:53	AugustoMauch	Review Assigned To	=> AugustoMauch
2012-11-05 16:53	AugustoMauch	Note Added: 0053997
2012-11-05 16:53	AugustoMauch	Status	resolved => closed
2012-11-05 16:53	AugustoMauch	Fixed in Version	=> 3.0MP17
2012-11-06 10:47	hudsonbot	Checkin
2012-11-06 10:47	hudsonbot	Note Added: 0054029
2017-09-18 18:59	caristu	Relationship added	related to 0036863