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

[nobody at svn.erp5.org]

Author: jerome
Date: Mon Dec 10 15:05:23 2007
New Revision: 18179

URL: http://svn.erp5.org?rev=18179&view=rev
Log:
prepand the table name to prevent OperationalError  (1052, "Column
'portal_type' in field list is ambiguous") that happens when a related key is
used in the generated query.


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=18179&r1=18178&r2=18179&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py (original)
+++ erp5/trunk/products/ERP5Form/Extensions/Folder_getWorkflowActionDocumentList.py Mon Dec 10 15:05:23 2007
@@ -67,9 +67,10 @@
       selection_params = \
               selection_tool.getSelectionParamsFor(selection_name).copy()
       selection_params['where_expression'] = '%s is not NULL' % workflow_state
-      selection_params['group_by'] = ('portal_type', workflow_state)
+      selection_params['group_by'] = ('catalog.portal_type', workflow_state)
       selection_params['select_expression'] = (
-           'count(catalog.uid) as count, portal_type, %s' % workflow_state)
+          'count(catalog.uid) as count, catalog.portal_type, %s'
+            % workflow_state)
       
       for brain in self.searchFolder(**selection_params):
         doc = brain.getObject()