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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015438
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2010-12-15 13:422011-10-28 18:08
ReportershuehnerView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionout of dateFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00152173.0RC4 closedalostale Moving forward / back arrows not working in Reconciliation tab 

-  Notes
(0033212)
shuehner (administrator)
2010-12-15 18:05

Note also failing in oracle but error message different 'column ambigously defined'
(0042280)
dmitry_mezentsev (developer)
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.

- Issue History
Date Modified Username Field Change
2010-12-15 13:42 shuehner New Issue
2010-12-15 13:42 shuehner Assigned To => alostale
2010-12-15 13:42 shuehner Modules => Core
2010-12-15 13:44 shuehner Relationship added related to 0015217
2010-12-15 18:05 shuehner Note Added: 0033212
2010-12-20 08:46 alostale Status new => scheduled
2011-10-28 18:08 dmitry_mezentsev Note Added: 0042280
2011-10-28 18:08 dmitry_mezentsev Status scheduled => closed
2011-10-28 18:08 dmitry_mezentsev Resolution open => out of date
2011-10-28 18:08 dmitry_mezentsev Fixed in Version => pi


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker