Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019505Openbravo ERP07. Sales managementpublic2012-01-17 11:432022-02-01 08:08
Reporterrgoris 
Assigned ToTriage Platform Base 
PriorityhighSeveritymajorReproducibilityN/A
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0019505: Incorrect linked items: Lines without headers
DescriptionSee attached I have a line without header. How is that possible?
Steps To ReproduceI produced this one by clicking Linked items in Goods Shipment, then again linked items in Return Material Receipt, see step 1 and step 2 images attached.
Proposed SolutionNote from Psarobe:

Hi Rob for pointing this out. I guess is something related with Linked items. As far as I know it is not working properly is some scenarios. I have already entered an issue about this and Dmitry did the same. Maybe your case is a different one so please enter en issue.

The problem is that at some point the system should go to window A but it is going to window B (both windows share the same tables) and window A cannot show headers of Window B so it shows the lines of window A in window B but Window B cannot show headers of Window A

https://issues.openbravo.com/view.php?id=19345 [^]
https://issues.openbravo.com/view.php?id=19347 [^]
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0019345 closed alostale Openbravo ERP Direct browsing not working as expected in some scenarios 
related to design defect 0019347 new Triage Platform Base Openbravo ERP Regular Sales Order gets incorrectly linked to the Return from Customer and Return Receipt 
blocks defect 0021096 closed alostale Retail Modules An imported regular ticket in web POS creates creates Customer and Vendor returns in BO 
blocks design defect 0019238 acknowledged Triage Platform Base Openbravo ERP Linked items fail when too many columns in Oracle 
Attached Filespng RFC line without header.PNG (69,128) 2012-01-17 11:43
https://issues.openbravo.com/file_download.php?file_id=4909&type=bug
png

png RFC line without header - step1.PNG (76,332) 2012-01-17 11:43
https://issues.openbravo.com/file_download.php?file_id=4910&type=bug
png

png RFC line without header - step2.PNG (98,016) 2012-01-17 11:43
https://issues.openbravo.com/file_download.php?file_id=4911&type=bug
png

png LinkedItems1.png (143,870) 2012-03-30 16:02
https://issues.openbravo.com/file_download.php?file_id=5114&type=bug
png

png LinkedItems2.png (115,242) 2012-03-30 16:02
https://issues.openbravo.com/file_download.php?file_id=5115&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-01-17 11:43rgorisNew Issue
2012-01-17 11:43rgorisAssigned To => jonalegriaesarte
2012-01-17 11:43rgorisFile Added: RFC line without header.PNG
2012-01-17 11:43rgorisModules => Core
2012-01-17 11:43rgorisFile Added: RFC line without header - step1.PNG
2012-01-17 11:43rgorisFile Added: RFC line without header - step2.PNG
2012-01-17 11:44rgorisRelationship addedrelated to 0019345
2012-01-17 11:44rgorisRelationship addedrelated to 0019347
2012-02-15 19:03iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 18:33vmromanosAssigned Tovmromanos => rgoris
2012-02-16 18:33vmromanosAssigned Torgoris => alostale
2012-03-30 15:15alostaleNote Added: 0046994
2012-03-30 15:15alostaleStatusnew => closed
2012-03-30 15:15alostaleResolutionopen => unable to reproduce
2012-03-30 16:02rgorisNote Added: 0046995
2012-03-30 16:02rgorisStatusclosed => new
2012-03-30 16:02rgorisResolutionunable to reproduce => open
2012-03-30 16:02rgorisFile Added: LinkedItems1.png
2012-03-30 16:02rgorisFile Added: LinkedItems2.png
2012-03-30 16:53alostaleNote Added: 0046996
2012-04-02 10:04alostaleNote Added: 0047291
2012-04-02 10:04alostaleTypedefect => design defect
2012-04-02 10:40alostaleStatusnew => scheduled
2012-04-02 10:40alostalefix_in_branch => pi
2012-04-02 10:41alostalePrioritynormal => urgent
2012-04-02 10:41alostalefix_in_branchpi =>
2012-07-16 11:22alostaleSummaryLines without headers => Incorrect linked items: Lines without headers
2012-07-16 11:22alostaleRelationship addedblocks 0021096
2012-09-10 13:16alostaleRelationship addedblocks 0019238
2012-09-24 20:55AugustoMauchNote Added: 0052401
2012-09-24 20:55AugustoMauchPriorityurgent => high
2017-03-31 14:36alostaleStatusscheduled => acknowledged
2017-04-10 14:33alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0046994)
alostale   
2012-03-30 15:15   
Working fine in current pi@c7a40d5e4b41
(0046995)
rgoris   
2012-03-30 16:02   
Asier, i just checked on live builds and the problem persists, see attached two new screenshots. Can you have a look again please? Thanks a heap!
(0046996)
alostale   
2012-03-30 16:53   
This issue occurs when the referenced tab's SQL where clause is not equivalent to its HQL where clause and the referenced record matches the SQL but not the HQL.

Linked items in 3.0 is based on the logic of 2.50 using SQL where clauses instead of HQL. This is incorrect as it should use HQL.
(0047291)
alostale   
2012-04-02 10:04   
Updating to design defect. Fix for this issue requires to redesign internals of linked items to use HQL clauses instead of SQL ones.
(0052401)
AugustoMauch   
2012-09-24 20:55   
Effort: 10
Impact: high
Plan: short