Story #15430

[API] Remove the @@ list method filter

Added by Eric Biagiotti almost 3 years ago. Updated 6 months ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Lucas Di Pentima
Category:
-
Target version:
2021-09-01 sprint
Start date:
08/16/2021
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
Story points:
1.0
Release:
Arvados 2.3.0
Release relationship:
Auto

Subtasks

Task #18022: Review 15430-fts-operator-removalResolvedLucas Di Pentima

Related issues

Related to Arvados - Feature #15429: [Workbench] Use trigram based full text search. Resolved10/15/2019

Blocked by Arvados - Story #15573: [API] Deprecate the @@ list method filterResolved11/19/2019

Blocks Arvados - Feature #17948: create some large collections for testing (on ce8i5, tordo, 9tee4)Resolved08/06/2021

Associated revisions

Revision f170c5a7
Added by Lucas Di Pentima 9 months ago

Merge branch '15430-fts-operator-removal' into main. Closes #15430

Arvados-DCO-1.1-Signed-off-by: Lucas Di Pentima <>

History

#1 Updated by Eric Biagiotti almost 3 years ago

  • Related to Feature #15429: [Workbench] Use trigram based full text search. added

#2 Updated by Eric Biagiotti almost 3 years ago

- Remove @@ code from record_filters.rb
- Create a migration that removes full text search indexes
- Update documentation
- Update/remove tests

#3 Updated by Tom Morris almost 3 years ago

  • Target version set to To Be Groomed

#4 Updated by Tom Morris over 2 years ago

  • Story points set to 1.0

#5 Updated by Tom Morris over 2 years ago

  • Related to Story #15573: [API] Deprecate the @@ list method filter added

#6 Updated by Tom Morris over 2 years ago

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

#7 Updated by Tom Morris over 2 years ago

  • Related to deleted (Story #15573: [API] Deprecate the @@ list method filter)

#8 Updated by Tom Morris over 2 years ago

  • Blocked by Story #15573: [API] Deprecate the @@ list method filter added

#9 Updated by Tom Morris over 2 years ago

  • Subject changed from [API] Deprecate the @@ list method filter to [API] Remove the @@ list method filter

#10 Updated by Peter Amstutz 11 months ago

  • Target version deleted (Arvados Future Sprints)

#11 Updated by Peter Amstutz 9 months ago

  • Target version set to 2021-08-18 sprint
  • Assigned To set to Lucas Di Pentima

#12 Updated by Lucas Di Pentima 9 months ago

  • Status changed from New to In Progress

#13 Updated by Lucas Di Pentima 9 months ago

  • Blocks Feature #17948: create some large collections for testing (on ce8i5, tordo, 9tee4) added

#14 Updated by Lucas Di Pentima 9 months ago

Updates at 6b30d1306 - branch 15430-fts-operator-removal
Test run: developer-run-tests: #2642
Test re-run: developer-run-tests-remainder: #2746

  • Removes support for the undocumented @@ filter operator.
  • Removes FTS indexes from the database.
  • Updates tests & documentation.

#15 Updated by Lucas Di Pentima 9 months ago

  • Target version changed from 2021-08-18 sprint to 2021-09-01 sprint

#16 Updated by Peter Amstutz 9 months ago

I would just adjust the text of the upgrading page a bit:

Removed deprecated '@@' search operator

The '@@' full text search operator, previously deprecated, has been removed. To perform a string search across multiple columns, use the 'ilike' operator on 'any' column as described in the "available list method filter section":{{site.baseurl}}/api/methods.html#substringsearchfilter of the API documentation.

rest LGTM

#17 Updated by Lucas Di Pentima 9 months ago

  • % Done changed from 0 to 100
  • Status changed from In Progress to Resolved

#18 Updated by Peter Amstutz 6 months ago

  • Release set to 42

Also available in: Atom PDF