Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036863Openbravo ERPA. Platformpublic2017-09-15 09:192017-09-25 10:35
caristu 
caristu 
highminoralways
closedfixed 
5
 
3.0PR17Q4 
alostale
Core
No
0036863: Custom Query Organization selectors information changes depending on the selected organization
Custom Query Organization selectors information changes depending on the selected organization. Once an organization has been selected, then just the organizations in the natural tree of the selected organization are displayed.
1) Login as "F&B International Group Admin" role
2) Go to the [Role] window
3) Select any record and move to the "Org Access" tab
4) Start editing a new record
5) Click on the selector drop-down: notice that all the organizations readable by the role are displayed
6) Select "F&B España Región Norte"
7) Click on the selector drop-down: notice that just the organizations in the natural tree of "F&B España Región Norte" are now displayed.

The same behavior happens in the "Process Price Different Adjustment" process, which has an Organization parameter using the same reference of the Organization field in the "Org Access" tab.
No tags attached.
related to defect 0036151 closed caristu organization selector in process definition don't filter by role's org access 
related to defect 0022085 closed ioritzCia Error when creating an hql query selector for organization. 
Issue History
2017-09-15 09:19caristuNew Issue
2017-09-15 09:19caristuAssigned To => platform
2017-09-15 09:19caristuModules => Core
2017-09-15 09:19caristuTriggers an Emergency Pack => No
2017-09-15 09:19caristuAssigned Toplatform => caristu
2017-09-15 09:19caristuRelationship addedrelated to 0036151
2017-09-18 18:59caristuRelationship addedrelated to 0022085
2017-09-19 09:02caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15929#r15929
2017-09-20 09:01caristuSummaryOrganization selectors information changes depending on the selected organization => Custom Query Organization selectors information changes depending on the selected organization
2017-09-20 09:01caristuDescription Updatedbug_revision_view_page.php?rev_id=15943#r15943
2017-09-20 09:19hgbotCheckin
2017-09-20 09:19hgbotNote Added: 0099161
2017-09-20 09:19hgbotStatusnew => resolved
2017-09-20 09:19hgbotResolutionopen => fixed
2017-09-20 09:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/576e33b667aaefa563869096ef60e3932c4b70f0 [^]
2017-09-20 09:20caristuReview Assigned To => alostale
2017-09-20 09:22hgbotCheckin
2017-09-20 09:22hgbotNote Added: 0099162
2017-09-20 09:41hgbotCheckin
2017-09-20 09:41hgbotNote Added: 0099164
2017-09-20 18:48hgbotCheckin
2017-09-20 18:48hgbotNote Added: 0099187
2017-09-20 18:54hgbotCheckin
2017-09-20 18:54hgbotNote Added: 0099188
2017-09-20 19:42hgbotCheckin
2017-09-20 19:42hgbotNote Added: 0099191
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099416
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099417
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099418
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099428
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099429
2017-09-21 16:50hudsonbotCheckin
2017-09-21 16:50hudsonbotNote Added: 0099430
2017-09-22 09:16alostaleNote Added: 0099457
2017-09-22 09:16alostaleStatusresolved => closed
2017-09-22 09:16alostaleFixed in Version => 3.0PR17Q4
2017-09-22 14:22caristuNote Added: 0099493
2017-09-25 10:35caristuNote Added: 0099516

Notes
(0099161)
hgbot   
2017-09-20 09:19   
Repository: erp/devel/pi
Changeset: 576e33b667aaefa563869096ef60e3932c4b70f0
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 08:57:10 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/576e33b667aaefa563869096ef60e3932c4b70f0 [^]

fixes bug 36863: wrong info in custom query org selector after selecting values

Custom query selectors filter their records by organization using the natural tree of the organization received in the ORG_PARAMETER (it contains the selected organization). This logic can not be applied on custom query selectors based on the AD_Org table because in that case the records displayed by the selector change depending on the selected organization.

To fix this issue, we handle custom query organization selectors as a special adding a filter with the organizations that are direct accessible by the role, without taking into account the selected organization.

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099162)
hgbot   
2017-09-20 09:22   
Repository: erp/devel/pi
Changeset: f5da0e1d9441deec7c1ba1660895e96b1fb3c5c0
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 09:02:31 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f5da0e1d9441deec7c1ba1660895e96b1fb3c5c0 [^]

related to issue 36863: improve comment

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099164)
hgbot   
2017-09-20 09:41   
Repository: erp/devel/pi
Changeset: 4fca4e4c0da6c30ad77a5a913c793395bc7c76ae
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 09:20:20 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4fca4e4c0da6c30ad77a5a913c793395bc7c76ae [^]

related to issue 36863: add missing quotes

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099187)
hgbot   
2017-09-20 18:48   
Repository: erp/devel/pi
Changeset: 668cc694e1b5c0f19decb9e2c206b3a48e868d78
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 18:29:04 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/668cc694e1b5c0f19decb9e2c206b3a48e868d78 [^]

related to bug 36863: take the access level from the table of selector's tab

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099188)
hgbot   
2017-09-20 18:54   
Repository: erp/devel/pi
Changeset: 03947bec5a0d5e85f20792b393b2594d7c555375
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 18:34:55 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/03947bec5a0d5e85f20792b393b2594d7c555375 [^]

related to bug 36863: add missing imports

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099191)
hgbot   
2017-09-20 19:42   
Repository: erp/devel/pi
Changeset: 103ab686dc05da5417c358431902f9aa74f9dc4b
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Sep 20 19:18:25 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/103ab686dc05da5417c358431902f9aa74f9dc4b [^]

related to bug 36863: return the readable organizations in the current context

Be homogeneus with the OBUISEL_Selector references based on the standard datasource (which use the AdvanceQueryBuilder to create the client/org filters) and filter by the readable organizations in the case of the AD_Org table

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0099416)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099417)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099418)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099428)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099429)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099430)
hudsonbot   
2017-09-21 16:50   
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/9750b78d3e5c [^]
Maturity status: Test
(0099457)
alostale   
2017-09-22 09:16   
reviewed + tested
(0099493)
caristu   
2017-09-22 14:22   
Repository: erp/devel/pi
Changeset: d91644da48fa51a49d2ccb5b8cde8d19179035e3
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Sep 22 14:02:09 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d91644da48fa51a49d2ccb5b8cde8d19179035e3 [^]

related to issue 36151, 36863: added test case

---
M src-test/src/org/openbravo/test/AllWebserviceTests.java
A src-test/src/org/openbravo/test/datasource/OrganizationSelectorDataSourceTest.java
(0099516)
caristu   
2017-09-25 10:35   
Repository: erp/devel/pi
Changeset: e638c65868bc
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Sep 25 10:13:24 2017 +0200
URL: https://code.openbravo.com/erp/devel/pi/rev/e638c65868bc [^] [^]

related to issues 36151, 36863 : code review improvements for test case

---
M src-test/src/org/openbravo/test/AllWebserviceTests.java
M src-test/src/org/openbravo/test/datasource/OrganizationSelectorDataSourceTest.java
---