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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010647
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2009-09-17 16:382024-02-07 05:04
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityhighResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchpiFixed in SCM revisione48a07e326b0
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

0010647: 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 ]
depends on backport 00108112.40MP11 closedalostale Table reference with ID in "Displayed Column" field gives an error in grid view. 

-  Notes
(0020160)
rafaroda (developer)
2009-09-18 07:04

Asier,

Can you please comment on this issue?

Thanks.
(0020599)
alostale (manager)
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 (reporter)
2009-10-19 11:56

While accessing the "Matched Invoices" window in grid view there is no error.
Tested & Working fine.

- Issue History
Date Modified Username Field Change
2009-09-17 16:38 networkb New Issue
2009-09-17 16:38 networkb Assigned To => rafaroda
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
Powered by Mantis Bugtracker