0015438: Sorting by more than one column (at the same time) fails in Reconciliation tab of the Financial Account window

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015438

Openbravo ERP

A. Platform

public

2010-12-15 13:42

2011-10-28 18:08

Reporter

shuehner

Assigned To

alostale

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

out of date

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0015438: Sorting by more than one column (at the same time) fails in Reconciliation tab of the Financial Account window

Description

Sorting 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 Reproduce

Go 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