Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010647Openbravo ERP00. Application dictionarypublic2009-09-17 16:382024-02-07 05:04
networkb 
alostale 
highminoralways
closedfixed 
5
2.40MP9 
2.40MP112.50MP7 
Core
No
0010647: Table reference with ID in "Displayed Column" field gives an error in grid view.
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"
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
No tags attached.
depends on backport 00108112.40MP11 closed alostale Table reference with ID in "Displayed Column" field gives an error in grid view. 
Issue History
2009-09-17 16:38networkbNew Issue
2009-09-17 16:38networkbAssigned To => rafaroda
2009-09-18 07:04rafarodaNote Added: 0020160
2009-09-18 07:04rafarodaAssigned Torafaroda => alostale
2009-09-18 07:04rafarodaStatusnew => acknowledged
2009-09-29 13:20psarobePriorityimmediate => high
2009-09-29 13:21psarobeStatusacknowledged => scheduled
2009-09-29 13:21psarobefix_in_branch => pi
2009-09-30 16:18alostaleNote Added: 0020599
2009-09-30 16:20hgbotCheckin
2009-09-30 16:20hgbotNote Added: 0020600
2009-09-30 16:20hgbotStatusscheduled => resolved
2009-09-30 16:20hgbotResolutionopen => fixed
2009-09-30 16:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e48a07e326b09e4a58dd64dd835d934ba17514d7 [^]
2009-10-19 11:56arunkumarStatusresolved => closed
2009-10-19 11:56arunkumarNote Added: 0021167
2009-10-19 11:56arunkumarFixed in Version => 2.50MP7
2009-10-20 00:00anonymoussf_bug_id0 => 2882004
2024-02-07 05:04adamusaNote Added: 0160320
2024-02-07 15:26shuehnerNote Deleted: 0160320

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

Can you please comment on this issue?

Thanks.
(0020599)
alostale   
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   
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   
2009-10-19 11:56   
While accessing the "Matched Invoices" window in grid view there is no error.
Tested & Working fine.