Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0025264
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajoralways2013-12-02 19:112014-03-14 07:50
ReporterchelipfView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_27
OS VersionDebian WheezyDatabase version9.1Ant version1.8.2
Product Version3.0MP29.1SCM revision 
Review Assigned To
Web browserMozilla Firefox
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025264: 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.
TagsSidesoft
Attached Filespng file icon Captura de pantalla de 2013-12-02 13:06:17.png [^] (125,734 bytes) 2013-12-02 19:11


png file icon Captura de pantalla de 2013-12-02 13:10:02.png [^] (151,426 bytes) 2013-12-02 19:13


png file icon Captura de pantalla de 2013-12-02 13:11:08.png [^] (150,754 bytes) 2013-12-02 19:13


png file icon Captura de pantalla de 2013-12-02 13:11:18.png [^] (153,012 bytes) 2013-12-02 19:13


png file icon Captura de pantalla de 2013-12-02 13:11:25.png [^] (150,689 bytes) 2013-12-02 19:13


png file icon Captura de pantalla de 2013-12-02 13:11:35.png [^] (155,203 bytes) 2013-12-02 19:14

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 00249223.0MP30 closedshankarb Fields that use a table reference extension are not displayed properly in grid view 

-  Notes
(0062500)
AugustoMauch (administrator)
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 (reporter)
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.

- Issue History
Date Modified Username Field Change
2013-12-02 19:11 chelipf New Issue
2013-12-02 19:11 chelipf Assigned To => AugustoMauch
2013-12-02 19:11 chelipf File Added: Captura de pantalla de 2013-12-02 13:06:17.png
2013-12-02 19:11 chelipf Web browser => Mozilla Firefox
2013-12-02 19:11 chelipf Modules => Core
2013-12-02 19:11 chelipf Triggers an Emergency Pack => No
2013-12-02 19:12 chelipf Tag Attached: Sidesoft
2013-12-02 19:13 chelipf File Added: Captura de pantalla de 2013-12-02 13:10:02.png
2013-12-02 19:13 chelipf File Added: Captura de pantalla de 2013-12-02 13:11:08.png
2013-12-02 19:13 chelipf File Added: Captura de pantalla de 2013-12-02 13:11:18.png
2013-12-02 19:13 chelipf File Added: Captura de pantalla de 2013-12-02 13:11:25.png
2013-12-02 19:14 chelipf File Added: Captura de pantalla de 2013-12-02 13:11:35.png
2013-12-02 19:16 chelipf Issue Monitored: chelipf
2013-12-04 09:53 AugustoMauch Note Added: 0062500
2013-12-04 09:53 AugustoMauch Status new => feedback
2013-12-04 21:44 chelipf Note Added: 0062534
2014-03-14 07:50 alostale Relationship added duplicate of 0024922
2014-03-14 07:50 alostale Status feedback => closed
2014-03-14 07:50 alostale Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker