Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025264Openbravo ERP00. Application dictionarypublic2013-12-02 19:112014-03-14 07:50
Reporterchelipf 
Assigned ToAugustoMauch 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS VersionDebian Wheezy
Product Version3.0MP29.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserMozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025264: Primary key in grid list when displaying a "table reference" column which displayed column is a foreign key ("table, tabledir)
DescriptionI have created a table reference in which the displayed column is a foreign key (table, tabledir) column in the table. This is the schema.


Table1 (orderline) -> Table2 (budget certificate line) -> Table3 (budget item)

budgetlinne_id (table1 ref) budgetitem_id (table2 ref)
                   

the displayed column of table1 refeference is Table2.budgetitem_id, and the displayed column of table2 reference is Table3.name. Finally the displayed value of table2 reference must be Table3.name and the displayed value of table1 reference must be the same, Table3.name.


All the tables has defined one column identifier different than primary key.

It works properly in edit mode and grid edit mode, but when listing the grid it shows primary key value of Table3.


Steps To ReproduceCreate a table reference in which displayed column points to another table or tabledir column.
Proposed Solution
Additional Information
TagsSidesoft
Relationships
duplicate of defect 00249223.0MP30 closed shankarb Fields that use a table reference extension are not displayed properly in grid view 
Attached Filespng Captura de pantalla de 2013-12-02 13:06:17.png (125,734) 2013-12-02 19:11
https://issues.openbravo.com/file_download.php?file_id=6545&type=bug
png

png Captura de pantalla de 2013-12-02 13:10:02.png (151,426) 2013-12-02 19:13
https://issues.openbravo.com/file_download.php?file_id=6546&type=bug
png

png Captura de pantalla de 2013-12-02 13:11:08.png (150,754) 2013-12-02 19:13
https://issues.openbravo.com/file_download.php?file_id=6547&type=bug
png

png Captura de pantalla de 2013-12-02 13:11:18.png (153,012) 2013-12-02 19:13
https://issues.openbravo.com/file_download.php?file_id=6548&type=bug
png

png Captura de pantalla de 2013-12-02 13:11:25.png (150,689) 2013-12-02 19:13
https://issues.openbravo.com/file_download.php?file_id=6549&type=bug
png

png Captura de pantalla de 2013-12-02 13:11:35.png (155,203) 2013-12-02 19:14
https://issues.openbravo.com/file_download.php?file_id=6550&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2013-12-02 19:11chelipfNew Issue
2013-12-02 19:11chelipfAssigned To => AugustoMauch
2013-12-02 19:11chelipfFile Added: Captura de pantalla de 2013-12-02 13:06:17.png
2013-12-02 19:11chelipfWeb browser => Mozilla Firefox
2013-12-02 19:11chelipfModules => Core
2013-12-02 19:11chelipfTriggers an Emergency Pack => No
2013-12-02 19:12chelipfTag Attached: Sidesoft
2013-12-02 19:13chelipfFile Added: Captura de pantalla de 2013-12-02 13:10:02.png
2013-12-02 19:13chelipfFile Added: Captura de pantalla de 2013-12-02 13:11:08.png
2013-12-02 19:13chelipfFile Added: Captura de pantalla de 2013-12-02 13:11:18.png
2013-12-02 19:13chelipfFile Added: Captura de pantalla de 2013-12-02 13:11:25.png
2013-12-02 19:14chelipfFile Added: Captura de pantalla de 2013-12-02 13:11:35.png
2013-12-02 19:16chelipfIssue Monitored: chelipf
2013-12-04 09:53AugustoMauchNote Added: 0062500
2013-12-04 09:53AugustoMauchStatusnew => feedback
2013-12-04 21:44chelipfNote Added: 0062534
2014-03-14 07:50alostaleRelationship addedduplicate of 0024922
2014-03-14 07:50alostaleStatusfeedback => closed
2014-03-14 07:50alostaleResolutionopen => duplicate

Notes
(0062500)
AugustoMauch   
2013-12-04 09:53   
Hi chelipf,

Thanks for your feedback. We think the case you are describing was fixed in this issue [1]

Could you please apply this patch [2] and see if you are still able to reproduce the issue.

Regards

[1] https://issues.openbravo.com/view.php?id=24922. [^]
[2] https://code.openbravo.com/erp/devel/pi/rev/e3a8f5f3ca3b483febb036b94c866e8b452e9727 [^]
(0062534)
chelipf   
2013-12-04 21:44   
That's it Augusto, it works properly. Thank you. I guess it will be fixed in MP30, doesn't it?

Thank you very much.