From a40f985557975eaf4987925724b09c46f6decaf6 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Tue, 17 Jun 2025 11:47:54 +0200 Subject: 🐛 searches - raw search index: better management of terms with spaces MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- ishtar_common/views_item.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'ishtar_common/views_item.py') diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py index 82548932f..444a157e4 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -1031,12 +1031,13 @@ def _search_manage_search_vector( if search_query: if "extras" not in dct: dct["extras"] = [] + table = model._meta.db_table dct["extras"].append( { "where": [ - f"{model._meta.db_table}.search_vector @@ (to_tsquery(%s, %s)) = true OR " + - f"{model._meta.db_table}.search_vector @@ (to_tsquery('simple', %s)) = true OR " - f"{model._meta.db_table}.search_vector::tsvector @@ %s::tsquery = true" + f"{table}.search_vector @@ (to_tsquery(%s, %s)) = true OR " + f"{table}.search_vector @@ (to_tsquery('simple', %s)) = true OR " + f"{table}.search_vector::tsvector @@ %s::tsquery = true" ], "params": [settings.ISHTAR_SEARCH_LANGUAGE, search_query, search_query, search_query], -- cgit v1.2.3