details: /erp/devel/pi/rev/fa4d6a6b3d7d changeset: 12136:fa4d6a6b3d7d user: Stefan Hühner <stefan.huehner <at> openbravo.com> date: Thu May 12 17:36:54 2011 +0200 summary: Fixed 17143: fixed hql where clause in two tabs - Employee Expense - Invoiceable Expenses in both tabs the conversion from sql-whereclause -> hql-whereclause introduced some bug which this cset fixes.
diffstat: src-db/database/sourcedata/AD_TAB.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (21 lines): diff -r ccdcc3aca320 -r fa4d6a6b3d7d src-db/database/sourcedata/AD_TAB.xml --- a/src-db/database/sourcedata/AD_TAB.xml Thu May 12 17:01:11 2011 +0200 +++ b/src-db/database/sourcedata/AD_TAB.xml Thu May 12 17:36:54 2011 +0200 @@ -4298,7 +4298,7 @@ <!--431--> <ISSORTTAB><![CDATA[N]]></ISSORTTAB> <!--431--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--431--> <UIPATTERN><![CDATA[RO]]></UIPATTERN> -<!--431--> <HQLWHERECLAUSE><![CDATA[e in (select t1.businessPartner from TimeAndExpenseSheet as t1, TimeAndExpenseSheetLine as t2 where t1=t2.timeSheet and t1.processed='Y' and t2.reinvoice='Y' and t2.salesOrderLine is null))]]></HQLWHERECLAUSE> +<!--431--> <HQLWHERECLAUSE><![CDATA[e in (select t1.businessPartner from TimeAndExpenseSheet as t1, TimeAndExpenseSheetLine as t2 where t1=t2.expenseSheet and t1.processed='Y' and t2.reinvoice='Y' and t2.salesOrderLine is null))]]></HQLWHERECLAUSE> <!--431--></AD_TAB> <!--432--><AD_TAB> @@ -4397,7 +4397,7 @@ <!--456--> <ISSORTTAB><![CDATA[N]]></ISSORTTAB> <!--456--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--456--> <UIPATTERN><![CDATA[RO]]></UIPATTERN> -<!--456--> <HQLWHERECLAUSE><![CDATA[e in (select t1.businessPartner from TimeAndExpenseSheet as t1, TimeAndExpenseSheetLine as t2 where t1=t2.timeSheet and t1.processed='Y' and t2.timeSheet<>'Y' and t2.invoiceLine is null))]]></HQLWHERECLAUSE> +<!--456--> <HQLWHERECLAUSE><![CDATA[e in (select t1.businessPartner from TimeAndExpenseSheet as t1, TimeAndExpenseSheetLine as t2 where t1=t2.expenseSheet and t1.processed='Y' and t2.timeSheet<>'Y' and t2.invoiceLine is null))]]></HQLWHERECLAUSE> <!--456--></AD_TAB> <!--457--><AD_TAB> ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
