Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0031304Openbravo ERPA. Platformpublic2015-10-29 18:532022-02-01 08:05
caristu 
Triage Platform Base 
normalminoralways
acknowledgedopen 
5
 
 
No
Core
No
0031304: Behavior of summary functions with property fields pointing to table references is not correct
Behavior of summary functions with property fields pointing to table references is not correct. The displayed information is not correct (See attached)
1. Setup steps
1.1 As system admin
1.2 Open Window, Tabs and Fields
1.3 Open Sales Order, Header tab
1.4 Add a new Field:
  * Name: sales rep
  * Property: salesRepresentative.email
  * Show in Grid View: true

2. Reproduce steps
2.1 Login to ERP
2.2 Open Sales Order
2.3 Add a summary field for the new property field. The output is not correct.
The problem is on the AdvancedQueryBuilder.addSelectFunctionPart(). The getPropertyForTableReference() is replacing the email value with the displayed value of the related table reference. This is not correct.

There are two possible solutions:

a) Do not call that method for the cases where is not needed (for example when localField does not contain the $_identifier value)

b) Send directly from the client side the display field of the table reference in the getSummarySettings() function (Similar to the fix for related issue https://issues.openbravo.com/view.php?id=30800 [^])
No tags attached.
related to defect 0030800 closed caristu Filter on Property field in a table reference column doesn't work 
png summaryFieldForPropertyField.png (6,909) 2015-10-29 18:53
https://issues.openbravo.com/file_download.php?file_id=8668&type=bug
png
Issue History
2015-10-29 18:53caristuNew Issue
2015-10-29 18:53caristuAssigned To => platform
2015-10-29 18:53caristuFile Added: summaryFieldForPropertyField.png
2015-10-29 18:53caristuOBNetwork customer => No
2015-10-29 18:53caristuModules => Core
2015-10-29 18:53caristuTriggers an Emergency Pack => No
2015-10-29 18:53caristuIssue Monitored: networkb
2015-10-29 18:53caristuRelationship addedrelated to 0030800
2015-10-29 18:58caristuProposed Solution updated
2015-10-29 19:05caristuProposed Solution updated
2015-10-29 19:06caristuProposed Solution updated
2015-11-04 09:12alostaleStatusnew => acknowledged
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.