Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020629Openbravo ERPA. Platformpublic2012-05-29 12:022012-06-06 10:14
Reportergorkaion 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Versionpi 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020629: Selector using custom query filters out system client
DescriptionThe Custom Query datasource for selectors adds a client filter that only include current client. This is wrong as readable clients include System.
Steps To ReproduceCreate a custom query selector based on a table that include records in System (Currency, AlertRules, Country,...)
Include it on a Window or Process.
Check that records in System are not available.
Proposed SolutionInclude System client ('0') in the client filter of the datasource.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-29 12:02gorkaionNew Issue
2012-05-29 12:02gorkaionAssigned To => gorkaion
2012-05-29 12:02gorkaionModules => Core
2012-05-29 12:02gorkaionOBNetwork customer => No
2012-05-31 18:29hgbotCheckin
2012-05-31 18:29hgbotNote Added: 0049554
2012-05-31 18:29hgbotStatusnew => resolved
2012-05-31 18:29hgbotResolutionopen => fixed
2012-05-31 18:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f2f8cfff59086f9f4d9d3b88eb8bcfaa66c3238 [^]
2012-06-02 17:18hudsonbotCheckin
2012-06-02 17:18hudsonbotNote Added: 0049589
2012-06-06 10:14miruritaNote Added: 0049639
2012-06-06 10:14miruritaStatusresolved => closed
2012-06-06 10:14miruritaFixed in Version => 3.0MP12

Notes
(0049554)
hgbot   
2012-05-31 18:29   
Repository: erp/devel/pi
Changeset: 5f2f8cfff59086f9f4d9d3b88eb8bcfaa66c3238
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue May 29 12:03:21 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f2f8cfff59086f9f4d9d3b88eb8bcfaa66c3238 [^]

Fixed issue 20629.Filter by readable clients instead of current client.

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0049589)
hudsonbot   
2012-06-02 17:18   
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/d1995ebc438c [^]

Maturity status: Test
(0049639)
mirurita   
2012-06-06 10:14   
Testing Plan
1) Check as System Administrator 'Product Attribute Selector' reference. It queries m_attributesetinstance table and there is always a record for client=0 and org=0.
2) Create a new Return from Customer
   - Org: F&B España - Región Norte
   - Business Partner: Alimentos y Supermercados, S.A
3) Create a new preference
   - Org: *
   - Property: RM Allow Orphan Line
   - Value: Y
4) Logout and login again
5) Click on Insert Orphan Line
6) Select a product: Agua sin gas
7) Check on Attribute selector that the m_attributesetinstance with id=0 is there (--)