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 | c9e7e5478aed8757821827e8f5358d7959257a2d (patch) | |
| tree | d27d1e598f6e665f0bd624cc1523440008ba7697 /ishtar_common/views_item.py | |
| parent | c2691ba59e40433b46b6c8aa3d362c56e6262788 (diff) | |
| download | Ishtar-c9e7e5478aed8757821827e8f5358d7959257a2d.tar.bz2 Ishtar-c9e7e5478aed8757821827e8f5358d7959257a2d.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 |