diff options
author | Étienne Loks <etienne.loks@iggdrasil.net> | 2023-01-18 23:33:56 +0100 |
---|---|---|
committer | Étienne Loks <etienne.loks@iggdrasil.net> | 2023-01-19 18:06:55 +0100 |
commit | 34e5e81e7afe240b05f2df834d21e08dbb4bcf79 (patch) | |
tree | d27d1e598f6e665f0bd624cc1523440008ba7697 /ishtar_common/views_item.py | |
parent | 803ce58a52cf818e874954cbf89237ba819027bc (diff) | |
download | Ishtar-34e5e81e7afe240b05f2df834d21e08dbb4bcf79.tar.bz2 Ishtar-34e5e81e7afe240b05f2df834d21e08dbb4bcf79.zip |
Free search: "raw" index for reference - improve parent only search
Diffstat (limited to 'ishtar_common/views_item.py')
-rw-r--r-- | ishtar_common/views_item.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py index 821a6635f..f905d677c 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -835,9 +835,11 @@ def _search_manage_search_vector( { "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" + f"{model._meta.db_table}.search_vector @@ (to_tsquery('simple', %s)) = true OR " + f"{model._meta.db_table}.search_vector::tsvector @@ %s::tsquery = true" ], - "params": [settings.ISHTAR_SEARCH_LANGUAGE, search_query, search_query], + "params": [settings.ISHTAR_SEARCH_LANGUAGE, search_query, search_query, + search_query], } ) return dct, exc_dct, distinct_queries |