Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010413Openbravo ERPA. Platformpublic2009-08-26 15:582022-02-01 08:08
ReporterNeha Mathur 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS10OS VersionXP Professional - SP2
Product Version2.50 
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
Summary0010413: Column with List reference does not show proper data when used as identifiers
DescriptionI have a table in which, I had marked a column as identifier which has a reference of list type. While referencing its record in a another table, it shows many records, but there are only few records in that table.
Steps To ReproducePlease refer the attached file for table structure.

1. Consider table CUS_TABLE1 with a column - MYLIST, which has a reference type - "List".
2. Mark that column as identifier.
3. Go to the window created for CUS_TABLE1 and create some records.
4. Now go to the window created for CUS_TABLE2 and create a new record. For the CUS_TABLE1_ID field on that window, you will find more records than the actual ones.
Proposed SolutionThe value for selected list reference should be displayed correctly, same as other identifiers.
Additional Information
TagsOB3-Reviewed
Relationships
Attached Files? List identifier bug.sql (1,571) 2009-08-26 15:58
https://issues.openbravo.com/file_download.php?file_id=1685&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-08-26 15:58Neha MathurNew Issue
2009-08-26 15:58Neha MathurAssigned To => rafaroda
2009-08-26 15:58Neha MathurFile Added: List identifier bug.sql
2009-08-28 15:38rafarodaNote Added: 0019273
2009-08-28 15:38rafarodaAssigned Torafaroda => alostale
2009-08-28 15:38rafarodaStatusnew => acknowledged
2009-08-28 15:38rafarodaCategoryB. User interface => A. Platform
2011-11-17 15:54alostaleTag Attached: OB3-Reviewed
2011-11-17 15:54alostaleNote Added: 0042937
2012-04-26 15:15alostaleNote Added: 0048033
2012-04-26 15:15alostaleTypedefect => design defect
2017-04-10 14:37alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0019273)
rafaroda   
2009-08-28 15:38   
Asier,

Can you please comment on this issue?

Thanks.
(0042937)
alostale   
2011-11-17 15:54   
In OB 3.0 it shown properly in form view but not in grid
(0048033)
alostale   
2012-04-26 15:15   
Setting as design defect: it requires quite a big refactor in very central parts of the infrastructure. Needs to be revisited.