diff options
| author | Étienne Loks <etienne.loks@iggdrasil.net> | 2025-06-17 11:47:54 +0200 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@iggdrasil.net> | 2025-06-17 11:51:37 +0200 |
| commit | a40f985557975eaf4987925724b09c46f6decaf6 (patch) | |
| tree | b380007da1aab4d2e9934b6f878707950d1f28bf /ishtar_common/views_item.py | |
| parent | 7ecbd4831e706691e7d0204976d56630f2c9d113 (diff) | |
| download | Ishtar-a40f985557975eaf4987925724b09c46f6decaf6.tar.bz2 Ishtar-a40f985557975eaf4987925724b09c46f6decaf6.zip | |
🐛 searches - raw search index: better management of terms with spaces
Diffstat (limited to 'ishtar_common/views_item.py')
| -rw-r--r-- | ishtar_common/views_item.py | 7 |
1 files changed, 4 insertions, 3 deletions
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], |