Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015438Openbravo ERPA. Platformpublic2010-12-15 13:422011-10-28 18:08
Reportershuehner 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015438: Sorting by more than one column (at the same time) fails in Reconciliation tab of the Financial Account window
DescriptionSorting my multiple tabs in grid view of that tab fails with an sql error that the alias 'td0' in the sql is used multiple times.

Example failing query:
ELECT COALESCE(TO_CHAR(APRM_Reconciliation_v.DocumentNo),'') AS DocumentNo , TO_CHAR(APRM_Reconciliation_v.Dateto, 'DD-MM-YYYY') AS Dateto , TO_NUMBER(APRM_Reconciliation_v.Endingbalance) AS Endingbalance , CAST(APRM_Reconciliation_v.Item_No AS INTEGER) AS Item_No , CAST(APRM_Reconciliation_v.Unrec_No AS INTEGER) AS Unrec_No , CAST(APRM_Reconciliation_v.Payment_No AS INTEGER) AS Payment_No , CAST(APRM_Reconciliation_v.Deposit_No AS INTEGER) AS Deposit_No , COALESCE(TO_CHAR(APRM_Reconciliation_v.Aprm_Reconciliation_V_ID),'') AS Aprm_Reconciliation_V_ID , APRM_Reconciliation_v.FIN_Reconciliation_ID AS FIN_Reconciliation_ID , COALESCE(TO_CHAR(td0.DocumentNo),'') || ' - ' || TO_CHAR(td0.Statementdate, 'DD-MM-YYYY') AS FIN_Reconciliation_ID_R
FROM APRM_Reconciliation_v
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID
 
WHERE (APRM_Reconciliation_v.Aprm_Reconciliation_V_ID, APRM_Reconciliation_v.FIN_Reconciliation_ID) IN (SELECT APRM_Reconciliation_v.Aprm_Reconciliation_V_ID, APRM_Reconciliation_v.FIN_Reconciliation_ID
 FROM APRM_Reconciliation_v
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID
 
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID
 
 WHERE APRM_Reconciliation_v.AD_Client_ID IN ('0','1000000')
 AND APRM_Reconciliation_v.AD_Org_ID IN ('1000009','1000006','1000005','1000000','0','1000008','1000007','1000004','1000002','1000003')
 AND APRM_Reconciliation_v.FIN_Financial_Account_ID = ?
Steps To ReproduceGo to: Financial Account
Tab: Reconciliation
Go to grid view
click on header or first tab to sort by it
ctrl+click on header of second tab (to add second sort criteria)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00152173.0RC4 closed alostale Moving forward / back arrows not working in Reconciliation tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-15 13:42shuehnerNew Issue
2010-12-15 13:42shuehnerAssigned To => alostale
2010-12-15 13:42shuehnerModules => Core
2010-12-15 13:44shuehnerRelationship addedrelated to 0015217
2010-12-15 18:05shuehnerNote Added: 0033212
2010-12-20 08:46alostaleStatusnew => scheduled
2011-10-28 18:08dmitry_mezentsevNote Added: 0042280
2011-10-28 18:08dmitry_mezentsevStatusscheduled => closed
2011-10-28 18:08dmitry_mezentsevResolutionopen => out of date
2011-10-28 18:08dmitry_mezentsevFixed in Version => pi

Notes
(0033212)
shuehner   
2010-12-15 18:05   
Note also failing in oracle but error message different 'column ambigously defined'
(0042280)
dmitry_mezentsev   
2011-10-28 18:08   
Once again cannot reproduce it.

Tab was redesigned maybe that is the case.

If you see here different issue please register it.

Thanks.