[Erp5-report] r36095 yusei - /erp5/trunk/products/CMFCategory/CategoryTool.py

[nobody at svn.erp5.org]

Author: yusei
Date: Tue Jun  8 14:51:02 2010
New Revision: 36095

URL: http://svn.erp5.org?rev=36095&view=rev
Log:
Allow 0(zero) value. This is needed for "non-left join" version of
predicate category search.

Modified:
    erp5/trunk/products/CMFCategory/CategoryTool.py

Modified: erp5/trunk/products/CMFCategory/CategoryTool.py
URL: http://svn.erp5.org/erp5/trunk/products/CMFCategory/CategoryTool.py?rev=36095&r1=36094&r2=36095&view=diff
==============================================================================
--- erp5/trunk/products/CMFCategory/CategoryTool.py [utf8] (original)
+++ erp5/trunk/products/CMFCategory/CategoryTool.py [utf8] Tue Jun  8 14:51:02 2010
@@ -1535,8 +1535,8 @@
               (category_uid_name, renderUIDWithOperator(base_category_uid)))
           else:
             # In any other case, allow it.
-            where_expression_list.append('(%s IS NULL OR %s IN (%s))' % \
-              (category_uid_name, category_uid_name,
+            where_expression_list.append('(%s IS NULL OR %s = 0 OR %s IN (%s))' % \
+              (category_uid_name, category_uid_name, category_uid_name,
                ', '.join([renderUIDValue(x) for x in category_uid_list])))
         result['from_expression'] = {catalog_table_name:
           ('\nLEFT JOIN `%s` AS ' % (query_table, )).join(left_join_list)}