[Erp5-report] r26901 - /erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/

[nobody at svn.erp5.org]

Author: jp
Date: Sat May  9 19:12:34 2009
New Revision: 26901

URL: http://svn.erp5.org?rev=26901&view=rev
Log:
Fixed missing join expression which was leading to bogus SQL requests

Modified:
    erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/WebSection_zGetDocumentValueList.xml

Modified: erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/WebSection_zGetDocumentValueList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/WebSection_zGetDocumentValueList.xml?rev=26901&r1=26900&r2=26901&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/WebSection_zGetDocumentValueList.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_web/SkinTemplateItem/portal_skins/erp5_web/WebSection_zGetDocumentValueList.xml [utf8] Sat May  9 19:12:34 2009
@@ -174,6 +174,10 @@
           AND my_versioning.language = <dtml-sqlvar language type="string">\n
         </dtml-if>\n
 \n
+        <dtml-if is_translation_order_by>\n
+          AND catalog.validation_state = related_translation_intermediate.original_message\n
+        </dtml-if>\n
+\n
       ORDER BY\n
         priority DESC\n
 \n
@@ -294,6 +298,10 @@
           AND my_versioning.language = <dtml-sqlvar language type="string">\n
         </dtml-if>\n
 \n
+        <dtml-if is_translation_order_by>\n
+          AND catalog.validation_state = related_translation_intermediate.original_message\n
+        </dtml-if>\n
+\n
       ORDER BY\n
         priority DESC\n
 \n