[Erp5-report] r19651 - /erp5/trunk/products/ERP5/Tool/DomainTool.py

[nobody at svn.erp5.org]

Author: seb
Date: Mon Mar  3 15:37:24 2008
New Revision: 19651

URL: http://svn.erp5.org?rev=19651&view=rev
Log:
join with the predicate_category table only when it is necassary, this should fix many problems when expanding the simulation

Modified:
    erp5/trunk/products/ERP5/Tool/DomainTool.py

Modified: erp5/trunk/products/ERP5/Tool/DomainTool.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/Tool/DomainTool.py?rev=19651&r1=19650&r2=19651&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/Tool/DomainTool.py (original)
+++ erp5/trunk/products/ERP5/Tool/DomainTool.py Mon Mar  3 15:37:24 2008
@@ -148,6 +148,8 @@
                context.getCategoryMembershipList(tested_base_category, base=1))
 
       if tested_base_category_list != []:
+        # Add predicate_category.uid for automatic join
+        sql_kw['predicate_category.uid'] = '!=0'
         if len(category_list)==0:
           category_list = ['NULL']
         category_expression = portal_categories.buildSQLSelector(
@@ -160,8 +162,6 @@
           where_expression = category_expression
 
       sql_kw['where_expression'] = where_expression
-      # Add predicate_category.uid for automatic join
-      sql_kw['predicate_category.uid'] = '!=0'
       kw.update(sql_kw)
 #       LOG('searchPredicateList, kw',0,kw)