Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0022932 | Openbravo ERP | A. Platform | public | 2013-01-30 09:55 | 2013-02-26 12:57 |
|
| Reporter | mirurita | |
| Assigned To | AugustoMauch | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | pi | |
| Target Version | 3.0MP21 | Fixed in Version | 3.0MP21 | |
| Merge Request Status | |
| Review Assigned To | shankarb |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0022932: 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 Reproduce | 1) 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 | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  issue22932.diff (763) 2013-02-04 15:06
https://issues.openbravo.com/file_download.php?file_id=5929&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-01-30 09:55 | mirurita | New Issue | |
| 2013-01-30 09:55 | mirurita | Assigned To | => AugustoMauch |
| 2013-01-30 09:55 | mirurita | Modules | => Core |
| 2013-01-30 09:55 | mirurita | OBNetwork customer | => Yes |
| 2013-01-30 09:55 | mirurita | Triggers an Emergency Pack | => No |
| 2013-02-04 15:06 | AugustoMauch | File Added: issue22932.diff | |
| 2013-02-04 15:07 | AugustoMauch | Note Added: 0056132 | |
| 2013-02-04 15:07 | AugustoMauch | Status | new => scheduled |
| 2013-02-04 15:07 | AugustoMauch | fix_in_branch | => pi |
| 2013-02-12 12:49 | hgbot | Checkin | |
| 2013-02-12 12:49 | hgbot | Note Added: 0056374 | |
| 2013-02-12 12:49 | hgbot | Status | scheduled => resolved |
| 2013-02-12 12:49 | hgbot | Resolution | open => fixed |
| 2013-02-12 12:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60680700bf23e85b5ac54c0dd8a301 [^] |
| 2013-02-12 12:50 | AugustoMauch | Review Assigned To | => shankarb |
| 2013-02-12 12:51 | AugustoMauch | Issue Monitored: shankarb | |
| 2013-02-20 04:50 | hudsonbot | Checkin | |
| 2013-02-20 04:50 | hudsonbot | Note Added: 0056580 | |
| 2013-02-26 12:56 | shankarb | Note Added: 0056772 | |
| 2013-02-26 12:56 | shankarb | Status | resolved => closed |
| 2013-02-26 12:56 | shankarb | Fixed in Version | => 3.0MP21 |
| 2013-02-26 12:56 | shankarb | Note Added: 0056773 | |
| 2013-02-26 12:56 | shankarb | Status | closed => new |
| 2013-02-26 12:56 | shankarb | Resolution | fixed => open |
| 2013-02-26 12:56 | shankarb | Fixed in Version | 3.0MP21 => |
| 2013-02-26 12:56 | shankarb | Note Deleted: 0056772 | |
| 2013-02-26 12:57 | shankarb | Status | new => scheduled |
| 2013-02-26 12:57 | shankarb | Status | scheduled => resolved |
| 2013-02-26 12:57 | shankarb | Resolution | open => fixed |
| 2013-02-26 12:57 | shankarb | Note Added: 0056774 | |
| 2013-02-26 12:57 | shankarb | Status | resolved => closed |
| 2013-02-26 12:57 | shankarb | Fixed in Version | => 3.0MP21 |
|
Notes |
|
|
|
|
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
---
|
|
|
|
|
|
|
|
(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 |
|