[Erp5-report] r18327 - /erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5...

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Dec 14 14:03:58 2007
New Revision: 18327

URL: http://svn.erp5.org?rev=18327&view=rev
Log:
Handle the case where owner does not have view permission on object. It cannot be handled with a NULL nicely, because NOT(NULL) AND [...] is always false in SQL, and it is required to negate conditions automaticaly for worklists.

Modified:
    erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml
    erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml

Modified: erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml?rev=18327&r1=18326&r2=18327&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml Fri Dec 14 14:03:58 2007
@@ -68,7 +68,7 @@
 <dtml-var sql_delimiter>\n
 CREATE TABLE `worklist_cache` (\n
   `count` INT UNSIGNED NOT NULL,\n
-  `owner` VARCHAR(32) NOT NULL,\n
+  `owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
   `security_uid` INT UNSIGNED NOT NULL,\n
   `portal_type` VARCHAR(255) NOT NULL,\n
   `validation_state` VARCHAR(255) NULL,\n
@@ -121,7 +121,7 @@
 <dtml-var sql_delimiter>\n
 CREATE TABLE `worklist_cache` (\n
   `count` INT UNSIGNED NOT NULL,\n
-  `owner` VARCHAR(32) NOT NULL,\n
+  `owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
   `security_uid` INT UNSIGNED NOT NULL,\n
   `portal_type` VARCHAR(255) NOT NULL,\n
   `validation_state` VARCHAR(255) NULL,\n

Modified: erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml?rev=18327&r1=18326&r2=18327&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml Fri Dec 14 14:03:58 2007
@@ -114,7 +114,7 @@
 <dtml-in prefix="loop" expr="_.range(_.len(count))">\n
   (\n
   <dtml-sqlvar expr="count[loop_item]" type="int">,\n
-  <dtml-sqlvar expr="owner[loop_item]" type="string">,\n
+  <dtml-sqlvar expr="owner[loop_item]" type="string" optional>,\n
   <dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
   <dtml-sqlvar expr="portal_type[loop_item]" type="string">,\n
   <dtml-sqlvar expr="validation_state[loop_item]" type="string" optional>,\n
@@ -168,7 +168,7 @@
 <dtml-in prefix="loop" expr="_.range(_.len(count))">\n
   (\n
   <dtml-sqlvar expr="count[loop_item]" type="int">,\n
-  <dtml-sqlvar expr="owner[loop_item]" type="string">,\n
+  <dtml-sqlvar expr="owner[loop_item]" type="string" optional>,\n
   <dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
   <dtml-sqlvar expr="portal_type[loop_item]" type="string">,\n
   <dtml-sqlvar expr="validation_state[loop_item]" type="string" optional>,\n