[Erp5-report] r18180 - /erp5/trunk/products/ERP5Form/Extensions/

[nobody at svn.erp5.org]

Author: jerome
Date: Mon Dec 10 15:10:35 2007
New Revision: 18180

URL: http://svn.erp5.org?rev=18180&view=rev
Log:
for the same reasons as r18179, the table name also need to be prepended to
workflow state column

Modified:
    erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py

Modified: erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py?rev=18180&r1=18179&r2=18180&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py (original)
+++ erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py Mon Dec 10 15:10:35 2007
@@ -66,10 +66,12 @@
     for workflow_state in possible_state_list:
       selection_params = \
               selection_tool.getSelectionParamsFor(selection_name).copy()
-      selection_params['where_expression'] = '%s is not NULL' % workflow_state
-      selection_params['group_by'] = ('catalog.portal_type', workflow_state)
+      selection_params['where_expression'] = \
+                        'catalog.%s is not NULL' % workflow_state
+      selection_params['group_by'] = ('catalog.portal_type',
+                                      'catalog.%s' % workflow_state)
       selection_params['select_expression'] = (
-          'count(catalog.uid) as count, catalog.portal_type, %s'
+          'count(catalog.uid) as count, catalog.portal_type, catalog.%s'
             % workflow_state)
       
       for brain in self.searchFolder(**selection_params):