Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010811
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 00. Application dictionaryminoralways2009-09-17 16:382009-10-12 09:12
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityhighResolutionfixedFixed in Version2.40MP10
StatusclosedFix in branch2.40Fixed in SCM revisionf9cde7a7ef91
ProjectionnoneETAnoneTarget Version2.40MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP9SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010811: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00106472.40MP11 closedalostale Table reference with ID in "Displayed Column" field gives an error in grid view. 

-  Notes
(0020603)
hgbot (developer)
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 (reporter)
2009-10-12 09:12

Tested working fine

- Issue History
Date Modified Username Field Change
2009-09-29 13:21 psarobe Type defect => backport
2009-09-29 13:21 psarobe fix_in_branch => 2.40
2009-09-30 16:34 hgbot Checkin
2009-09-30 16:34 hgbot Note Added: 0020603
2009-09-30 16:34 hgbot Status scheduled => resolved
2009-09-30 16:34 hgbot Resolution open => fixed
2009-09-30 16:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/f9cde7a7ef9169d70d19437e50f70fb456f23517 [^]
2009-10-12 09:12 sureshbabu Status resolved => closed
2009-10-12 09:12 sureshbabu Note Added: 0020935
2009-10-12 09:12 sureshbabu Fixed in Version => 2.40MP10


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker