Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010811Openbravo ERP00. Application dictionarypublic2009-09-17 16:382009-10-12 09:12
Reporternetworkb 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP9 
Target Version2.40MP11Fixed in Version2.40MP10 
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
Summary0010811: Table reference with ID in "Displayed Column" field gives an error in grid view.
DescriptionYou 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 Reproduce1. 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00106472.40MP11 closed alostale Table reference with ID in "Displayed Column" field gives an error in grid view. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-29 13:21psarobeTypedefect => backport
2009-09-29 13:21psarobefix_in_branch => 2.40
2009-09-30 16:34hgbotCheckin
2009-09-30 16:34hgbotNote Added: 0020603
2009-09-30 16:34hgbotStatusscheduled => resolved
2009-09-30 16:34hgbotResolutionopen => fixed
2009-09-30 16:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/f9cde7a7ef9169d70d19437e50f70fb456f23517 [^]
2009-10-12 09:12sureshbabuStatusresolved => closed
2009-10-12 09:12sureshbabuNote Added: 0020935
2009-10-12 09:12sureshbabuFixed in Version => 2.40MP10

Notes
(0020603)
hgbot   
2009-09-30 16:34   
Repository: erp/stable/2.40
Changeset: f9cde7a7ef9169d70d19437e50f70fb456f23517
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 30 16:34:12 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/f9cde7a7ef9169d70d19437e50f70fb456f23517 [^]

fixed bug 0010811: Table reference with ID in Displayed Column field gives an error in grid view.

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0020935)
sureshbabu   
2009-10-12 09:12   
Tested working fine