Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007506Openbravo ERP00. Application dictionarypublic2009-02-11 16:422009-04-22 00:00
Reporternetworkb 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007506: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0007595 closed alostale 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 closed rafaroda Linked items pop-up not shows all references 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-11 16:42networkbNew Issue
2009-02-11 16:42networkbAssigned To => rafaroda
2009-02-11 16:42networkbOBNetwork customer => Yes
2009-02-11 16:42networkbRegression testing => No
2009-02-12 10:42rafarodaAssigned Torafaroda => alostale
2009-02-12 11:21alostaleNote Added: 0013397
2009-02-12 11:21alostaleStatusnew => feedback
2009-02-13 17:30networkbNote Added: 0013488
2009-02-13 17:42networkbStatusfeedback => new
2009-02-16 17:38networkbSummaryThe 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:38networkbDescription Updated
2009-02-16 17:38networkbProposed Solution updated
2009-02-17 13:10rafarodaStatusnew => scheduled
2009-02-17 13:10rafarodafix_in_branch => trunk
2009-02-18 12:44svnbotCheckin
2009-02-18 12:44svnbotNote Added: 0013636
2009-02-18 12:44svnbotStatusscheduled => resolved
2009-02-18 12:44svnbotResolutionopen => fixed
2009-02-18 12:44svnbotsvn_revision => 13306
2009-02-20 09:13pjuvaraRelationship addedhas duplicate 0007439
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777927

Notes
(0013397)
alostale   
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   
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   
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 [^]