Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0010647 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 00. Application dictionary | minor | always | 2009-09-17 16:38 | 2024-02-07 05:04 | |||
Reporter | networkb | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | high | Resolution | fixed | Fixed in Version | 2.50MP7 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | e48a07e326b0 | |||
Projection | none | ETA | none | Target Version | 2.40MP11 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.40MP9 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
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 | 0010647: Table reference with ID in "Displayed Column" field gives an error in grid view. | |||||||
Description | You create a Reference and in its Table Reference tab selects same value for Displayed Column and Key Column. Then you associate this reference to other field in another tab and compiles the window. When accessing this window in Grid View, it throws the following error: "ERROR: column reference "c_invoiceline_id" is ambiguous" | |||||||
Steps To Reproduce | 1. Application Dictionary || Reference: Validation Type=Table Validation 2. Application Dictionary || Reference >> Table Reference : Table=c_invoiceline Key Column=c_invoiceline_id Displayed Column=c_invoiceline_id 3. Application Dictionary || Windows, Tabs, and Fields: go to window "Matched Invoices", tab "Matched Invoice" and field "Invoice Line". 4. Press "Column" link and set: Reference=Table Reference Search Key= our reference 5. Compile the window 6. Try to access Procurement Management || Transactions || Matched Invoices || Matched Invoice, and you will get the error | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0020160) rafaroda (viewer) 2009-09-18 07:04 |
Asier, Can you please comment on this issue? Thanks. |
(0020599) alostale (viewer) 2009-09-30 16:18 |
It does not make much sense to display in the table reference the internal ID which should only be internally used. The only situation where this could make sense is in case the ID to be used is not one of these UUIDs. |
(0020600) hgbot (developer) 2009-09-30 16:20 |
Repository: erp/devel/pi Changeset: e48a07e326b09e4a58dd64dd835d934ba17514d7 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Wed Sep 30 16:19:35 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/e48a07e326b09e4a58dd64dd835d934ba17514d7 [^] fixed bug 0010647: Table reference with ID in Displayed Column field gives an error in grid view. --- M src/org/openbravo/erpCommon/utility/TableSQLData.java --- |
(0021167) arunkumar (viewer) 2009-10-19 11:56 |
While accessing the "Matched Invoices" window in grid view there is no error. Tested & Working fine. |
![]() |
|||
Date Modified | Username | Field | Change |
2009-09-17 16:38 | networkb | New Issue | |
2009-09-17 16:38 | networkb | Assigned To | => rafaroda |
2009-09-17 16:38 | networkb | OBNetwork customer | => Yes |
2009-09-18 07:04 | rafaroda | Note Added: 0020160 | |
2009-09-18 07:04 | rafaroda | Assigned To | rafaroda => alostale |
2009-09-18 07:04 | rafaroda | Status | new => acknowledged |
2009-09-29 13:20 | psarobe | Priority | immediate => high |
2009-09-29 13:21 | psarobe | Status | acknowledged => scheduled |
2009-09-29 13:21 | psarobe | fix_in_branch | => pi |
2009-09-30 16:18 | alostale | Note Added: 0020599 | |
2009-09-30 16:20 | hgbot | Checkin | |
2009-09-30 16:20 | hgbot | Note Added: 0020600 | |
2009-09-30 16:20 | hgbot | Status | scheduled => resolved |
2009-09-30 16:20 | hgbot | Resolution | open => fixed |
2009-09-30 16:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e48a07e326b09e4a58dd64dd835d934ba17514d7 [^] |
2009-10-19 11:56 | arunkumar | Status | resolved => closed |
2009-10-19 11:56 | arunkumar | Note Added: 0021167 | |
2009-10-19 11:56 | arunkumar | Fixed in Version | => 2.50MP7 |
2009-10-20 00:00 | anonymous | sf_bug_id | 0 => 2882004 |
2024-02-07 05:04 | adamusa | Note Added: 0160320 | |
2024-02-07 15:26 | shuehner | Note Deleted: 0160320 |
Copyright © 2000 - 2009 MantisBT Group |