Search: explicit search vector reference

1 files changed, 5 insertions, 4 deletions

diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py
index 33f3f2092..1b6d1e724 100644
--- a/ishtar_common/views_item.py
+++ b/ishtar_common/views_item.py
@@ -429,7 +429,7 @@ def _parse_parentheses_groups(groups, request_keys, current_dct=None,
     return unidecode(query), current_dct, exc_dct
 
 
-def _search_manage_search_vector(dct, exc_dct, request_keys):
+def _search_manage_search_vector(model, dct, exc_dct, request_keys):
     if 'search_vector' not in dct:
         return dct, exc_dct
 
@@ -440,7 +440,8 @@ def _search_manage_search_vector(dct, exc_dct, request_keys):
     exc_dct.update(extra_exc_dct)
     if search_query:
         dct['extras'].append(
-            {'where': ["search_vector @@ (to_tsquery(%s, %s)) = true"],
+            {'where': [model._meta.db_table +
+                       ".search_vector @@ (to_tsquery(%s, %s)) = true"],
              'params': [settings.ISHTAR_SEARCH_LANGUAGE,
                         search_query]}
         )
@@ -973,8 +974,8 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
             request.session[func_name] = dct
 
         dct['extras'] = []
-        dct, excluded_dct = _search_manage_search_vector(dct, excluded_dct,
-                                                         request_keys)
+        dct, excluded_dct = _search_manage_search_vector(
+            model, dct, excluded_dct, request_keys)
         search_vector = ""
         if 'search_vector' in dct:
             search_vector = dct.pop('search_vector')