Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019596Openbravo ERPA. Platformpublic2012-01-31 09:312012-03-02 15:33
Reporterjecharri 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP9Fixed in Version3.0MP9 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019596: Selector are not working properly with fields that has one list as reference
DescriptionSelector are not working properly with fields that has one list as reference.

Yo can not filter by this field or drop down the values of the list.
Steps To ReproduceAs "System administrator" go to "reference" window:
-create one list as in image [warehouselist.png]
-go to window "Tables and columns" and select table "ProductByPriceAndWarehouse"
-select the column "M_Warehouse_ID" and put the list that you have just created as reference

As "Group Admin" go to window "Sales Invoice":
-Create a "header" and go to tab "Lines"
-Create one and push in the "magnifying glass" of product selector.
-You will see that the values of the list has not been displayed in the "warehouse" column and you can not filter by it

---
Alternative steps:
-Install attached module
-Change c_invonceline.c_tax_id reference to "Tax selector" provided by the module
-Generate entities
-Open Sales invoice, go to a line
-Open tax selector -> type column shows values instead of labels, it is not possible to filter by this propery
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00166883.0MP8 closed alostale List References and DateTime references are not displayed correctly in a Query Widget 
Attached Filespng warehouselist.png (301,613) 2012-01-31 09:31
https://issues.openbravo.com/file_download.php?file_id=4934&type=bug
? org.openbravo.issue19596-0.0.0.obx (4,951) 2012-02-01 18:12
https://issues.openbravo.com/file_download.php?file_id=4939&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-01-31 09:31jecharriNew Issue
2012-01-31 09:31jecharriAssigned To => alostale
2012-01-31 09:31jecharriFile Added: warehouselist.png
2012-01-31 09:31jecharriWeb browser => Google Chrome
2012-01-31 09:31jecharriModules => Core
2012-01-31 09:31jecharriResolution time => 1354489200
2012-01-31 11:42alostaleRelationship addedrelated to 0016688
2012-01-31 11:43alostaleAssigned Toalostale => AugustoMauch
2012-02-01 18:10alostaleAssigned ToAugustoMauch => alostale
2012-02-01 18:12alostaleFile Added: org.openbravo.issue19596-0.0.0.obx
2012-02-01 18:14alostaleWeb browserGoogle Chrome => Google Chrome
2012-02-01 18:14alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3120#r3120
2012-02-01 18:20alostaleNote Added: 0044783
2012-02-01 18:21hgbotCheckin
2012-02-01 18:21hgbotNote Added: 0044784
2012-02-01 18:21hgbotCheckin
2012-02-01 18:21hgbotNote Added: 0044785
2012-02-01 18:21hgbotStatusnew => resolved
2012-02-01 18:21hgbotResolutionopen => fixed
2012-02-01 18:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d3afc86a6e67126c202e0c0d1c70186e8498176e [^]
2012-02-06 12:13AugustoMauchNote Added: 0044885
2012-02-06 12:13AugustoMauchStatusresolved => closed
2012-02-06 12:13AugustoMauchFixed in Version => 3.0MP9
2012-03-02 15:33hudsonbotCheckin
2012-03-02 15:33hudsonbotNote Added: 0045723
2012-03-02 15:33hudsonbotCheckin
2012-03-02 15:33hudsonbotNote Added: 0045724

Notes
(0044783)
alostale   
2012-02-01 18:20   
This fix is not risky in terms of possible regression because it is very located in selector fields of Enum type which were not working before.

Test plan:
-Install attached module
-Change c_invonceline.c_tax_id reference to "Tax selector" provided by the module
-Generate entities
-Open Sales invoice, go to a line
-Open tax selector -> type column shows labels, it is possible to filter by this property
(0044784)
hgbot   
2012-02-01 18:21   
Repository: erp/devel/pi
Changeset: df09f1238c4c8ffc99e50e56482d444da71bf988
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Feb 01 18:16:19 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/df09f1238c4c8ffc99e50e56482d444da71bf988 [^]

related to bug 19596: created getAllowedValues convenience method

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceProperty.java
---
(0044785)
hgbot   
2012-02-01 18:21   
Repository: erp/devel/pi
Changeset: d3afc86a6e67126c202e0c0d1c70186e8498176e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Feb 01 18:18:21 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d3afc86a6e67126c202e0c0d1c70186e8498176e [^]

fixed bug 19596: Support for list references as selector fields

  Adding valueMap for list references within selectors

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorComponent.java
---
(0044885)
AugustoMauch   
2012-02-06 12:13   
Fix verified and code reviewed
(0045723)
hudsonbot   
2012-03-02 15:33   
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/544d64e0c159 [^]

Maturity status: Test
(0045724)
hudsonbot   
2012-03-02 15:33   
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/544d64e0c159 [^]

Maturity status: Test