Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023870Openbravo ERPA. Platformpublic2013-05-21 18:052013-06-04 07:22
Reportercaristu 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP24Fixed in Version3.0MP24 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023870: Property fields are not working properly with some properties
DescriptionProperty fields are not working properly depending on the selected property, if this property references a column with table/tabledir reference, the information is not displayed in grid view, and when trying to filter using this field an error is shown (see attachment)
Steps To ReproduceAs system administrator
1) Go to [Windows, Tabs and Fields] and select the Goods Shipment Window
2) In the [Field tab] create a new property field using the following property: shipmentReceipt.documentType
As group admin role
3) Go to the [Goods Shipment] window, display the property field we have created in 2) and notice that it doesn't show any information in grid view. Try to use the filter.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesjpg error.JPG (28,454) 2013-05-21 18:22
https://issues.openbravo.com/file_download.php?file_id=6151&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2013-05-21 18:05caristuNew Issue
2013-05-21 18:05caristuAssigned To => AugustoMauch
2013-05-21 18:05caristuModules => Core
2013-05-21 18:05caristuResolution time => 1372111200
2013-05-21 18:05caristuTriggers an Emergency Pack => No
2013-05-21 18:06caristuIssue Monitored: networkb
2013-05-21 18:23caristuFile Added: error.JPG
2013-05-22 11:15hgbotCheckin
2013-05-22 11:15hgbotNote Added: 0058744
2013-05-23 01:34hudsonbotCheckin
2013-05-23 01:34hudsonbotNote Added: 0058849
2013-05-24 08:57AugustoMauchIssue Monitored: mtaal
2013-05-24 08:57AugustoMauchReview Assigned To => mtaal
2013-05-24 08:58hgbotCheckin
2013-05-24 08:58hgbotNote Added: 0058924
2013-05-24 08:58hgbotCheckin
2013-05-24 08:58hgbotNote Added: 0058925
2013-05-24 08:58hgbotStatusnew => resolved
2013-05-24 08:58hgbotResolutionopen => fixed
2013-05-24 08:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5ac834636f948cf1c529bbab669aadc6284a7eb3 [^]
2013-05-24 16:50hudsonbotCheckin
2013-05-24 16:50hudsonbotNote Added: 0058940
2013-05-24 16:50hudsonbotCheckin
2013-05-24 16:50hudsonbotNote Added: 0058941
2013-06-04 07:22mtaalNote Added: 0059138
2013-06-04 07:22mtaalStatusresolved => closed
2013-06-04 07:22mtaalFixed in Version => 3.0MP24

Notes
(0058744)
hgbot   
2013-05-22 11:15   
Repository: erp/devel/pi
Changeset: 2f55fbbf66779261407c7e2267285123e3fa61e5
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed May 22 11:14:54 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2f55fbbf66779261407c7e2267285123e3fa61e5 [^]

Related to issue 23870: Foreign key property field values are shown in the grid

The problem was that the datasource was returning the identifier of the property field like this:
- shipmentReceipt.documentType$_identifier: 'MM Shipment'
instead of like this:
- shipmentReceipt$documentType$_identifier: 'MM Shipment'

When a new value is added in the DataToJsonConverter, the dots in the property names are replaced with '$' (DalUtil.FIELDSEPARATOR). There were some places were this replacement was not being done.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java
---
(0058849)
hudsonbot   
2013-05-23 01:34   
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/97c7f6256af7 [^]

Maturity status: Test
(0058924)
hgbot   
2013-05-24 08:58   
Repository: erp/devel/pi
Changeset: f3fe4a52f51e4de7c36d092ef1cd28ff9605dd56
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Fri May 24 08:52:11 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f3fe4a52f51e4de7c36d092ef1cd28ff9605dd56 [^]

Related to issue 23870: Fixes spacing of Java file

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0058925)
hgbot   
2013-05-24 08:58   
Repository: erp/devel/pi
Changeset: 5ac834636f948cf1c529bbab669aadc6284a7eb3
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Fri May 24 08:56:53 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ac834636f948cf1c529bbab669aadc6284a7eb3 [^]

Fixes issue 23870: Filters work properly with property columns

In the buildFieldClause method of the AdvancedQueryBuilder class there was a bug that prevented filtering from working in the case where the size of the properties array was longer than 2. This happened because at one point the useFieldName string was being truncated from the first occurrence of the point, when it should have been truncated from the last.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0058940)
hudsonbot   
2013-05-24 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/d2f5bade4728 [^]

Maturity status: Test
(0058941)
hudsonbot   
2013-05-24 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/d2f5bade4728 [^]

Maturity status: Test
(0059138)
mtaal   
2013-06-04 07:22   
Reviewed