Project

General

Profile

Actions

Feature #15106

closed

[API] Index 'like' queries and use for search

Added by Peter Amstutz almost 5 years ago. Updated almost 5 years ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Eric Biagiotti
Category:
-
Target version:
Story points:
2.0
Release relationship:
Auto

Description

Add a migration that creates trigram indexes on columns currently searchable by full text search. This should concatenate columns to create a single expression index (eg name || description || file_names).

Migration should execute "create extension pg_trgm" and provide a useful error message if the extension is not available (should advise the user to install postgres-contrib and/or link to the migration notes).

Update 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.


Subtasks 1 (0 open1 closed)

Task #15264: Review 15106-trgm-text-searchResolvedEric Biagiotti06/14/2019Actions

Related issues

Related to Arvados - Feature #14573: [Spike] [API] Fully functional filename searchResolvedPeter AmstutzActions
Actions

Also available in: Atom PDF