Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039441Openbravo ERPA. Platformpublic2018-10-11 18:112018-10-16 16:58
ReporterJONHM 
Assigned Toplatform 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039441: Organization Selector is not showing data from Organization
DescriptionOrganization Selector is not showing data from Organization. Because of this changeset [1], the inpadOrgId is not sent anymore and the validation of the HQL Where Clause of the selector is not getting this parameter nor the validation of this selector:
AD_ISORGINCLUDED(e.id, @inpadOrgId@,e.client.id)<>-1


[1] https://code.openbravo.com/erp/devel/pi/rev/ff888dbe2c3a51c0a28a6512cd8a57d9af5ba27e [^]
Steps To ReproduceInstall attached module
- Open "Test Selector" window
- Open the selector, it shows no data
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035124 closed inigosanchez Selectors in Process Definition invoked from menu show only records of organizations in the context organization's natural tree 
Attached Files? com.openbravo.test.selector-1.0.0.obx (4,307) 2018-10-11 18:11
https://issues.openbravo.com/file_download.php?file_id=12263&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-10-11 18:11JONHMNew Issue
2018-10-11 18:11JONHMAssigned To => Triage Finance
2018-10-11 18:11JONHMFile Added: com.openbravo.test.selector-1.0.0.obx
2018-10-11 18:11JONHMModules => Core
2018-10-11 18:11JONHMRegression date => 2018-10-15
2018-10-11 18:11JONHMTriggers an Emergency Pack => No
2018-10-11 18:15JONHMRelationship addedcaused by 0035124
2018-10-15 08:42SandrahuguetAssigned ToTriage Finance => platform
2018-10-15 08:42SandrahuguetCategory02. Master data management => A. Platform
2018-10-15 09:44JONHMDescription Updatedbug_revision_view_page.php?rev_id=17758#r17758
2018-10-15 12:50alostaleRegression level => Production - Confirmed Stable
2018-10-15 12:50alostaleRegression date2018-10-15 => 2017-03-01
2018-10-15 12:50alostaleRegression introduced in release => 3.0PR17Q2
2018-10-15 12:50alostaleRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/ff888dbe2c3a51c0a28a6512cd8a57d9af5ba27e [^]
2018-10-15 13:02AugustoMauchNote Added: 0107298
2018-10-15 13:02AugustoMauchStatusnew => closed
2018-10-15 13:02AugustoMauchResolutionopen => no change required
2018-10-16 16:57caristuRegression levelProduction - Confirmed Stable =>
2018-10-16 16:57caristuRegression date2017-03-01 =>
2018-10-16 16:57caristuRegression introduced in release3.0PR17Q2 =>
2018-10-16 16:57caristuRegression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/ff888dbe2c3a51c0a28a6512cd8a57d9af5ba27e [^] =>
2018-10-16 16:58caristuRelationship deletedcaused by 0035124
2018-10-16 16:58caristuRelationship addedrelated to 0035124

Notes
(0107298)
AugustoMauch   
2018-10-15 13:02   
The Organization Selector can be used in those process definitions that have an underlying grid (i.e. those that are opened by clicking a process button in a window), but not in those processes that are opened directly from the menu.

Before this change [1] the selector showed results even if belonged to a process definition open from the menu, but the results it showed were not right, because instead of showing the natural tree of the organizations writable by the current role, it only showed the natural tree of the current context organization.

Organization selectors in process definition cannot have a HQL Where Clause that reference inpadOrgId. It is not possible to just remove the where clause from the current Organization Selector because it is used at least in the Add Payment process that is triggered from the Match Stament process in the Financial Account window.

[1] https://code.openbravo.com/erp/devel/pi/rev/ff888dbe2c3a51c0a28a6512cd8a57d9af5ba27e [^]