[Erp5-report] r12175 - /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMe...

[nobody at svn.erp5.org]

Author: jp
Date: Sat Jan 20 21:05:50 2007
New Revision: 12175

URL: http://svn.erp5.org?rev=12175&view=rev
Log:
Added GROUP BY support

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_count_results.xml
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_search_results.xml

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_count_results.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_count_results.xml?rev=12175&r1=12174&r2=12175&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_count_results.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_count_results.xml Sat Jan 20 21:05:50 2007
@@ -166,6 +166,10 @@
     <dtml-if expression> AND <dtml-var expression> </dtml-if>\n
   </dtml-let>\n
 </dtml-if>\n
+<dtml-if group_by_expression>\n
+GROUP BY\n
+  <dtml-var group_by_expression>\n
+</dtml-if>\n
 <dtml-if sort_on>\n
 ORDER BY\n
   <dtml-var sort_on>\n

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_search_results.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_search_results.xml?rev=12175&r1=12174&r2=12175&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_search_results.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_ndb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_ndb/z_search_results.xml Sat Jan 20 21:05:50 2007
@@ -203,6 +203,10 @@
     <dtml-if expression> AND <dtml-var expression> </dtml-if>\n
   </dtml-let>\n
 </dtml-if>\n
+<dtml-if group_by_expression>\n
+GROUP BY\n
+  <dtml-var group_by_expression>\n
+</dtml-if>\n
 <dtml-if sort_on>\n
 ORDER BY\n
   <dtml-var sort_on>\n
@@ -211,8 +215,6 @@
 LIMIT <dtml-var "limit_expression">\n
 <dtml-else>\n
 LIMIT 1000\n
-</dtml-if>\n
-
 
 ]]></string> </value>
         </item>