liquid_feedback_frontend
diff model/member.lua @ 1492:faaf9ec3e09c
Fixed usage of text search index
| author | bsw |
|---|---|
| date | Mon Aug 26 15:49:37 2019 +0200 (2019-08-26) |
| parents | 32cc544d5a5b |
| children | 2a0d86117d54 |
line diff
1.1 --- a/model/member.lua Mon Aug 26 15:27:05 2019 +0200 1.2 +++ b/model/member.lua Mon Aug 26 15:49:37 2019 +0200 1.3 @@ -570,7 +570,7 @@ 1.4 function Member:get_search_selector(search_string) 1.5 return self:new_selector() 1.6 :add_field( {'"highlight"("member"."name", ?)', search_string }, "name_highlighted") 1.7 - :add_where{ '"member"."text_search_data" @@ "text_search_query"(?)', search_string } 1.8 + :add_where{ 'to_tsvector("member") @@ "plainto_tsquery"(?)', search_string } 1.9 :add_where("activated NOTNULL AND active") 1.10 end 1.11