Project

General

Profile

Feature #15106

Updated by Peter Amstutz about 5 years ago

Add a migration that creates trigram indexes on columns currently searchable by full text search. 

 Update workbench (1? 2?) workbench1 (and/or workbench2?) search bar to use ["any", "ilike", "%term%"] instead of '@@'.    Workbench should perform splitting of the search on whitespace and add a separate search clause for each term. 

 Question: join all columns into one big search (more efficient), or search each column separately (more flexible)? 

Back