Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007506 | Openbravo ERP | 00. Application dictionary | public | 2009-02-11 16:42 | 2009-04-22 00:00 |
|
| Reporter | networkb | |
| Assigned To | alostale | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | |
| Product Version | 2.40 | |
| Target Version | | Fixed in Version | 2.50beta | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0007506: The linked items button does not work if the column that referes the document has a name different than TABLENAME_ID |
| Description | If 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 Reproduce | 1-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 | |
| Tags | No 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 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 |
|
Notes |
|
|
|
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. |
|
|
|
|
|
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 [^]
|
|