Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022932Openbravo ERPA. Platformpublic2013-01-30 09:552013-02-26 12:57
Reportermirurita 
Assigned ToAugustoMauch 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target Version3.0MP21Fixed in Version3.0MP21 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022932: Computed columns (foreign key reference) are not ignored in the linked items
Description
computed columns with a foreign key reference (tabledir, ...) are not ignored in the linked items computation.

as the computed column does not exists in the database the select fails on

getLinkedItemCategories method on UsedByLink class

data = UsedByLinkData.select(this, vars.getClient(), vars.getLanguage(), vars.getRole(), keyColumnId, keyColumn, tableId, linkedColumnsQuery.toString());

Steps To Reproduce1) Install the following modules
https://code.openbravo.com/erp/mods/org.openbravo.contract/ [^]
https://code.openbravo.com/erp/pmods/org.openbravo.contract.services/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.services.template [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.hierarchical/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.hierarchical.template/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.eulen/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.project.budget/ [^]

2) Apply dataset for previous modules

3) Go to contract window
 3.1) Create a new contract header
 3.2) Create a new contract line

4) Click on 'Linked Items' and see the error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff issue22932.diff (763) 2013-02-04 15:06
https://issues.openbravo.com/file_download.php?file_id=5929&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-01-30 09:55miruritaNew Issue
2013-01-30 09:55miruritaAssigned To => AugustoMauch
2013-01-30 09:55miruritaModules => Core
2013-01-30 09:55miruritaTriggers an Emergency Pack => No
2013-02-04 15:06AugustoMauchFile Added: issue22932.diff
2013-02-04 15:07AugustoMauchNote Added: 0056132
2013-02-04 15:07AugustoMauchStatusnew => scheduled
2013-02-04 15:07AugustoMauchfix_in_branch => pi
2013-02-12 12:49hgbotCheckin
2013-02-12 12:49hgbotNote Added: 0056374
2013-02-12 12:49hgbotStatusscheduled => resolved
2013-02-12 12:49hgbotResolutionopen => fixed
2013-02-12 12:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60680700bf23e85b5ac54c0dd8a301 [^]
2013-02-12 12:50AugustoMauchReview Assigned To => shankarb
2013-02-12 12:51AugustoMauchIssue Monitored: shankarb
2013-02-20 04:50hudsonbotCheckin
2013-02-20 04:50hudsonbotNote Added: 0056580
2013-02-26 12:56shankarbNote Added: 0056772
2013-02-26 12:56shankarbStatusresolved => closed
2013-02-26 12:56shankarbFixed in Version => 3.0MP21
2013-02-26 12:56shankarbNote Added: 0056773
2013-02-26 12:56shankarbStatusclosed => new
2013-02-26 12:56shankarbResolutionfixed => open
2013-02-26 12:56shankarbFixed in Version3.0MP21 =>
2013-02-26 12:56shankarbNote Deleted: 0056772
2013-02-26 12:57shankarbStatusnew => scheduled
2013-02-26 12:57shankarbStatusscheduled => resolved
2013-02-26 12:57shankarbResolutionopen => fixed
2013-02-26 12:57shankarbNote Added: 0056774
2013-02-26 12:57shankarbStatusresolved => closed
2013-02-26 12:57shankarbFixed in Version => 3.0MP21

Notes
(0056132)
AugustoMauch   
2013-02-04 15:07   
A fix for this issue has been attached. It will be pushed to pi once pi is unfrozen.
(0056374)
hgbot   
2013-02-12 12:49   
Repository: erp/devel/pi
Changeset: 66d0835d6c60680700bf23e85b5ac54c0dd8a301
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Feb 12 12:49:06 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60680700bf23e85b5ac54c0dd8a301 [^]

Fixes issue 22932: Computed columns are ignored in the linked items

Computed columns (columns with sqllogic not null) are ignored in the linked items, to prevent trying to search for its physical column (they don't have one).

---
M src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---
(0056580)
hudsonbot   
2013-02-20 04:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d828167a9e83 [^]

Maturity status: Test
(0056773)
shankarb   
2013-02-26 12:56   
Reopened to modify Closed note.
(0056774)
shankarb   
2013-02-26 12:57   
Code reviewed and tested in pi changeset 059d60b862a4