Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017915Openbravo ERPA. Platformpublic2011-07-06 12:322011-08-12 13:39
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP2Fixed in Version3.0MP2 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017915: Multiple level table reference not shown properly in grid
DescriptionHaving a table T0 with a column C0 with table reference R1 to table T1, displayed column T1.C1. Having T1.C1 column a table reference to table T2.C2, displayed column C2.

When displaying tab for T0, column C0 should be displayed with the value in T2.C2: T0.C0->T1.C1->T2.C2.

This is works in form view and when editing the value in grid, but for existent records in grid view, identifier (including UUID) for T2 is shown.
Steps To Reproduce-Find attached a module that allows to reproduce it.
-Install the module
-Open Test 17915 window and add a record
-Open Sales Order window in grid mode
-Edit any record in grid view and select the created record in Test 17915 window. Note in the grid you see an Order document no.
-Save the record. Now instead of displaying document no it shows order identifier.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00164653.0RC7 closed mtaal Combos on new ui doesn't show the record identifiers 
related to defect 00161913.0MP2 closed alostale Payment proposal window: Lines tab shows UUID 
related to defect 00175263.0MP5 closed alostale Long identifier shown in lines tab 
related to defect 00180263.0MP3 closed alostale UUID is displayed in field "order UOM" in purchase order line 
related to defect 00183823.0MP5 closed alostale Productions line is wrong in grid view 
Attached Files? org.openbravo.issue17915-0.0.0.obx (15,834) 2011-07-13 09:04
https://issues.openbravo.com/file_download.php?file_id=4331&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-07-06 12:32alostaleNew Issue
2011-07-06 12:32alostaleAssigned To => alostale
2011-07-06 12:32alostaleModules => Core
2011-07-06 12:32alostaleRelationship addedrelated to 0016465
2011-07-06 12:33alostaleNote Added: 0038896
2011-07-06 12:34alostaleNote Edited: 0038896bug_revision_view_page.php?bugnote_id=0038896#r2363
2011-07-11 10:54gorkaionRelationship addedrelated to 0017526
2011-07-11 10:54gorkaionRelationship addedrelated to 0016191
2011-07-13 09:04alostaleFile Added: org.openbravo.issue17915-0.0.0.obx
2011-07-13 09:16alostaleDescription Updatedbug_revision_view_page.php?rev_id=2400#r2400
2011-07-13 09:16alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2402#r2402
2011-07-13 09:42alostaleNote Added: 0039024
2011-07-13 13:10hgbotCheckin
2011-07-13 13:10hgbotNote Added: 0039037
2011-07-13 13:10hgbotStatusnew => resolved
2011-07-13 13:10hgbotResolutionopen => fixed
2011-07-13 13:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cfdcbfbfb91afc601f31bd6d21a438c611fe0b21 [^]
2011-07-19 09:04malsasuaRelationship addedrelated to 0018026
2011-08-01 14:19hudsonbotCheckin
2011-08-01 14:19hudsonbotNote Added: 0039591
2011-08-12 13:39jonalegriaesarteNote Added: 0040163
2011-08-12 13:39jonalegriaesarteStatusresolved => closed
2011-08-12 13:39jonalegriaesarteFixed in Version => 3.0MP2
2011-08-30 08:54alostaleRelationship addedrelated to 0018382

Notes
(0038896)
alostale   
2011-07-06 12:33   
(edited on: 2011-07-06 12:34)
This can be seen in ob@ob3 in Sales Order window, proforma field
(0039024)
alostale   
2011-07-13 09:42   
Debugging DataToJsonConverter.addBaseOBObject in Sales Order window with the attached module.

referencingProperty Property (id=155)
    columnId "A88B8FB53967494FB435AD380F9477DA" (id=157)
    columnName "EM_Ob17915_Test_ID" (id=183)
    displayProperty "proforma" (id=185)
    domainType TableDomainType (id=186)
        entity.name Order

referencedProperty Property (id=152)
    columnId "6AFFB8D8C4254786B4AAD627622434D4" (id=159)
    columnName "Ob17915_Test_ID" (id=204)
    displayProperty null
    domainType UniqueIdDomainType (id=205)
        entity.name OB17915_test

Shouldn't referencedProperty column be Ob17915_Test.proforma with TableDomainType instead of Ob17915_Test.Ob17915_Test_ID UniqueIdDomainType?
(0039037)
hgbot   
2011-07-13 13:10   
Repository: erp/devel/pi
Changeset: cfdcbfbfb91afc601f31bd6d21a438c611fe0b21
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Jul 13 13:10:23 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cfdcbfbfb91afc601f31bd6d21a438c611fe0b21 [^]

fixed bug 017915: Multiple level table reference not shown properly in grid

  Allowing 2 levels deep

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java
---
(0039591)
hudsonbot   
2011-08-01 14:19   
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/cf2afed6e8ef [^]

Maturity status: Test
(0040163)
jonalegriaesarte   
2011-08-12 13:39   
Verified