From 31340edcfa49e044f6cb5d611ca62f917fdca1db Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Wed, 7 Dec 2022 10:50:51 +0100 Subject: Full text search: add "simple" config in search --- ishtar_common/views_item.py | 6 +++--- 1 file changed, 3 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 b8cc24fb4..2f9cfc55a 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -826,10 +826,10 @@ def _search_manage_search_vector( dct["extras"].append( { "where": [ - model._meta.db_table - + ".search_vector @@ (to_tsquery(%s, %s)) = true" + 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" ], - "params": [settings.ISHTAR_SEARCH_LANGUAGE, search_query], + "params": [settings.ISHTAR_SEARCH_LANGUAGE, search_query, search_query], } ) return dct, exc_dct, distinct_queries -- cgit v1.2.3