Fixes issue 20714: Using Oracle, no lines in the Pick and Exec for RFC
authorMikel Irurita <mikel.irurita@openbravo.com>
Fri, 08 Jun 2012 16:09:10 +0200
changeset 16795 25ca12e0813e
parent 16794 61fb6c14f182
child 16796 75bb6c439f80
Fixes issue 20714: Using Oracle, no lines in the Pick and Exec for RFC
src-db/database/sourcedata/AD_TAB.xml
--- a/src-db/database/sourcedata/AD_TAB.xml	Fri Jun 08 11:29:00 2012 +0200
+++ b/src-db/database/sourcedata/AD_TAB.xml	Fri Jun 08 16:09:10 2012 +0200
@@ -14248,7 +14248,7 @@
 <!--CC35784EF36B4732B40167CD5D2449F0-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
 <!--CC35784EF36B4732B40167CD5D2449F0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--CC35784EF36B4732B40167CD5D2449F0-->  <UIPATTERN><![CDATA[STD]]></UIPATTERN>
-<!--CC35784EF36B4732B40167CD5D2449F0-->  <HQLWHERECLAUSE><![CDATA[COALESCE(e.returnOrder.id, TO_CHAR(@Order.id@)) = @Order.id@
+<!--CC35784EF36B4732B40167CD5D2449F0-->  <HQLWHERECLAUSE><![CDATA[(e.returnOrder.id IS NULL OR e.returnOrder.id = @Order.id@)
 AND CASE WHEN e.salesTransaction = true THEN 'true' ELSE 'false' END = @Order.salesTransaction@
 AND e.businessPartner.id = @Order.businessPartner@]]></HQLWHERECLAUSE>
 <!--CC35784EF36B4732B40167CD5D2449F0-->  <HQLORDERBYCLAUSE><![CDATA[obSelected desc, movementDate desc, orderNo, product.name]]></HQLORDERBYCLAUSE>