liquid_feedback_frontend

changeset 1492:faaf9ec3e09c

Fixed usage of text search index
author bsw
date Mon Aug 26 15:49:37 2019 +0200 (2019-08-26)
parents 4badb51649f7
children 6b4deab5160a
files model/issue.lua model/member.lua
line diff
     1.1 --- a/model/issue.lua	Mon Aug 26 15:27:05 2019 +0200
     1.2 +++ b/model/issue.lua	Mon Aug 26 15:49:37 2019 +0200
     1.3 @@ -219,7 +219,7 @@
     1.4    return self:new_selector()
     1.5      :join('"initiative"', nil, '"initiative"."issue_id" = "issue"."id"')
     1.6      :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"')
     1.7 -    :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string }
     1.8 +    :add_where{ 'to_tsvector("initiative") @@ "plainto_tsquery"(?) OR to_tsvector("draft") @@ "plainto_tsquery"(?)', search_string, search_string }
     1.9      :add_group_by('"issue"."id"')
    1.10  end
    1.11  
     2.1 --- a/model/member.lua	Mon Aug 26 15:27:05 2019 +0200
     2.2 +++ b/model/member.lua	Mon Aug 26 15:49:37 2019 +0200
     2.3 @@ -570,7 +570,7 @@
     2.4  function Member:get_search_selector(search_string)
     2.5    return self:new_selector()
     2.6      :add_field( {'"highlight"("member"."name", ?)', search_string }, "name_highlighted")
     2.7 -    :add_where{ '"member"."text_search_data" @@ "text_search_query"(?)', search_string }
     2.8 +    :add_where{ 'to_tsvector("member") @@ "plainto_tsquery"(?)', search_string }
     2.9      :add_where("activated NOTNULL AND active")
    2.10  end
    2.11  

Impressum / About Us