Fixed bug #17786: Filtering repository list fields are not prefixed with tablename
authorsteffenk <steffenk@709f56b5-9817-0410-a4d7-c38de5d9e867>
Sun, 27 Feb 2011 13:39:43 +0000 (13:39 +0000)
committersteffenk <steffenk@709f56b5-9817-0410-a4d7-c38de5d9e867>
Sun, 27 Feb 2011 13:39:43 +0000 (13:39 +0000)
git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@10656 709f56b5-9817-0410-a4d7-c38de5d9e867

ChangeLog
typo3/sysext/em/classes/connection/class.tx_em_connection_extdirectserver.php

index 5e08c98..eead7a1 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,5 +1,6 @@
 2011-02-27  Steffen Kamper  <steffen@typo3.org>
 
+       * Fixed bug #17786: Filtering repository list fields are not prefixed with tablename
        * Follow-up to #17735: Class 'tx_em_XmlException' not found when Retrieve / Update
 
 2011-02-26  Steffen Kamper  <steffen@typo3.org>
index 047c112..5c58378 100644 (file)
@@ -1460,10 +1460,10 @@ class tx_em_Connection_ExtDirectServer {
                                switch ($value['data']['type']) {
                                        case 'list':
                                                if ($value['field'] === 'statevalue') {
-                                                       $where .= ' AND state IN(' . htmlspecialchars($value['data']['value']) . ')';
+                                                       $where .= ' AND cache_extensions.state IN(' . htmlspecialchars($value['data']['value']) . ')';
                                                }
-                                               if ($value['field'] === 'categoryvalue') {
-                                                       $where .= ' AND category IN(' . htmlspecialchars($value['data']['value']) . ')';
+                                               if ($value['field'] === 'category') {
+                                                       $where .= ' AND cache_extensions.category IN(' . htmlspecialchars($value['data']['value']) . ')';
                                                }
                                        break;
                                        default:
@@ -1471,7 +1471,7 @@ class tx_em_Connection_ExtDirectServer {
                                                        $GLOBALS['TYPO3_DB']->quoteStr($value['data']['value'], 'cache_extensions'),
                                                        'cache_extensions'
                                                );
-                                               $where .= ' AND ' . htmlspecialchars($value['field']) . ' LIKE "%' . $quotedSearch . '%"';
+                                               $where .= ' AND cache_extensions.' . htmlspecialchars($value['field']) . ' LIKE "%' . $quotedSearch . '%"';
                                }
                        }
                }