src/org/openbravo/erpCommon/ad_reports/ReportRefundInvoiceCustomerDimensionalAnalyses_data.xsql
changeset 573 48f214c7b66e
parent 423 ecf368072c48
child 1605 8a0fe0193bef
--- a/src/org/openbravo/erpCommon/ad_reports/ReportRefundInvoiceCustomerDimensionalAnalyses_data.xsql	Fri Mar 28 22:40:03 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportRefundInvoiceCustomerDimensionalAnalyses_data.xsql	Fri Mar 28 23:37:23 2008 +0000
@@ -212,7 +212,7 @@
               FROM AD_REF_LIST 
              WHERE AD_REFERENCE_ID = 800087
              AND AD_REF_LIST.VALUE IN ('1', '2', '3', '4', '5', '6')
-             ORDER BY VALUE) AA
+             ORDER BY TO_NUMBER(VALUE)) AA
       WHERE 1=1 
      ]]></Sql>
      <Parameter name="notShown" optional="true" type="argument" after="WHERE 1=1 "><![CDATA[AND ID NOT IN]]></Parameter>
@@ -226,7 +226,7 @@
               FROM AD_REF_LIST 
              WHERE AD_REFERENCE_ID = 800087 
              AND AD_REF_LIST.VALUE IN ('1', '2', '3', '4', '5', '6')
-             ORDER BY VALUE) AA
+             ORDER BY TO_NUMBER(VALUE)) AA
       WHERE 1=1 
      ]]></Sql>
      <Parameter name="shown" optional="true" type="argument" after="WHERE 1=1 "><![CDATA[AND ID IN]]></Parameter>
@@ -244,7 +244,7 @@
                AND l.AD_REF_LIST_ID  = t.AD_REF_LIST_ID
                AND L.VALUE IN ('1', '2', '3', '4', '5', '6')
                AND t.AD_LANGUAGE = ?
-             ORDER BY VALUE) AA
+             ORDER BY TO_NUMBER(VALUE)) AA
       WHERE 1=1 
      ]]></Sql>
      <Parameter name="lang"/> 
@@ -262,7 +262,7 @@
                AND l.AD_REF_LIST_ID  = t.AD_REF_LIST_ID
                AND L.VALUE IN ('1', '2', '3', '4', '5', '6')
                AND t.AD_LANGUAGE = ?
-             ORDER BY VALUE) AA
+             ORDER BY TO_NUMBER(VALUE)) AA
       WHERE 1=1 
      ]]></Sql>
      <Parameter name="lang"/>