Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015438 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2010-12-15 13:42 | 2011-10-28 18:08 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | out of date | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| 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) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0033212) shuehner (administrator) 2010-12-15 18:05 |
Note also failing in oracle but error message different 'column ambigously defined' |
|
(0042280) dmitry_mezentsev (viewer) 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. |
|
Notes |
|
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:42 | shuehner | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |