Add an "allTitles" index

Description

As discussed in (for the FOLIO Z39.50 server), we need the ability to search not only the title field, but all title-related fields. says that this will be very simple to set up — a matter of adding four lines to the mod-inventory-storage PostgreSQL schema — so we just need the go-ahead for this work to happen.

"allTitles" index is expected to cover:

  • Resource titles

  • All types of Alternative titles (defined in Settings > Inventory > Instances > Alternative title types

  • Series statements (= Series titles)

Environment

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Hongwei Ji February 5, 2021 at 6:29 PM

The change has been verified on my local environment. Database has the index created. Following queries (decoded for convenience) all return the modified The Girl on the Train record.

Holly Mistlebauer January 21, 2021 at 8:56 PM

: Thanks much!

Jakub Skoczen January 21, 2021 at 12:05 PM

I will talk to them team about it.

Holly Mistlebauer January 20, 2021 at 8:50 PM

: Would it be possible for this JIRA to be completed within the R1 2021 release? It has 1 story point. Thanks for considering this request...

Charlotte Whitt December 23, 2020 at 4:24 PM

Thanks

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

Release

R1 2021

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 18, 2020 at 5:41 PM
Updated March 10, 2021 at 3:46 PM
Resolved February 5, 2021 at 6:31 PM
TestRail: Cases
TestRail: Runs