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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007506
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajoralways2009-02-11 16:422009-04-22 00:00
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version2.50beta
StatusclosedFix in branchpiFixed in SCM revision13306
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007506: The linked items button does not work if the column that referes the document has a name different than TABLENAME_ID

DescriptionIf you define a new field in a window, and the colum name is different than TABLENAME_ID, the s linked items button does not work.
Steps To Reproduce1-Create a new column in the M_PRODUCTION table with name CUS_ORDERLINE_ID
2-Define this new column in the application dictionary on the table M_PRODUCTION
3-Define a new field in the header of the Production BOM related with the column defined in the step 2.
4-Compile the Production window
5-Go to the production window and fill the new field with a sales order line.
6-Navigate to the sales order line
7-Click the s linked items button and the link to the production does not appear.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0007595 closedalostale The linked items button does not work if the column that referes the document has a name different than TABLENAME_ID 
has duplicate defect 0007439 closedrafaroda Linked items pop-up not shows all references 

-  Notes
(0013397)
alostale (manager)
2009-02-12 11:21

Can you explain a little more 2nd step?

In fact, by default this new column will have a tableDir reference which is not correct in this case, tableDir references are used in case the column has the same name as the table they are refering to with a _ID suffix. Ex. MY_TABLE_ID column would be a reference to MY_TABLE table. In case the column does not follow this naming rule it is necessary to define a table reference.
(0013488)
networkb (developer)
2009-02-13 17:30

In the second step we defined the column with reference=search and Reference search key = Sales Order line
(0013636)
svnbot (reporter)
2009-02-18 12:44

Repository: openbravo
Revision: 13306
Author: alostale
Date: 2009-02-18 12:44:12 +0100 (Wed, 18 Feb 2009)

fixed bug 0007506: The linked items button does not work if the column that referes the document has a name different than TABLENAME_ID

---
U trunk/src/org/openbravo/erpCommon/utility/UsedByLink.java
U trunk/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13306&sc=1 [^]

- Issue History
Date Modified Username Field Change
2009-02-11 16:42 networkb New Issue
2009-02-11 16:42 networkb Assigned To => rafaroda
2009-02-11 16:42 networkb Regression testing => No
2009-02-12 10:42 rafaroda Assigned To rafaroda => alostale
2009-02-12 11:21 alostale Note Added: 0013397
2009-02-12 11:21 alostale Status new => feedback
2009-02-13 17:30 networkb Note Added: 0013488
2009-02-13 17:42 networkb Status feedback => new
2009-02-16 17:38 networkb Summary The reference button does not work if the column that referes the document has a name different than TABLENAME_ID => The linked items button does not work if the column that referes the document has a name different than TABLENAME_ID
2009-02-16 17:38 networkb Description Updated
2009-02-16 17:38 networkb Proposed Solution updated
2009-02-17 13:10 rafaroda Status new => scheduled
2009-02-17 13:10 rafaroda fix_in_branch => trunk
2009-02-18 12:44 svnbot Checkin
2009-02-18 12:44 svnbot Note Added: 0013636
2009-02-18 12:44 svnbot Status scheduled => resolved
2009-02-18 12:44 svnbot Resolution open => fixed
2009-02-18 12:44 svnbot svn_revision => 13306
2009-02-20 09:13 pjuvara Relationship added has duplicate 0007439
2009-04-21 10:33 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777927


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker