Feature #15106

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

Added by Peter Amstutz about 1 month ago. Updated about 1 month ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Story points:
2.0

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.


Related issues

Related to Arvados - Feature #14573: [Spike] [API] Fully functional filename searchResolved

History

#1 Updated by Peter Amstutz about 1 month ago

  • Status changed from New to In Progress

#2 Updated by Peter Amstutz about 1 month ago

  • Subject changed from Indexed like queries to [API] Index 'like' queries for search
  • Status changed from In Progress to New

#3 Updated by Peter Amstutz about 1 month ago

  • Related to Feature #14573: [Spike] [API] Fully functional filename search added

#4 Updated by Peter Amstutz about 1 month ago

  • Subject changed from [API] Index 'like' queries for search to [API] Index 'like' queries and use for search
  • Description updated (diff)

#5 Updated by Peter Amstutz about 1 month ago

  • Description updated (diff)

#6 Updated by Peter Amstutz about 1 month ago

  • Description updated (diff)

#7 Updated by Peter Amstutz about 1 month ago

  • Description updated (diff)
  • Story points set to 2.0

#8 Updated by Tom Morris about 1 month ago

  • Target version changed from To Be Groomed to Arvados Future Sprints

Also available in: Atom PDF