Inventory search | Title search | Support strings containing “and” or “&”

Description

Overview: Requirement raised by MSU: Support searching in inventory with strings containing “and” or “&” and getting results that contain the other (eg. “Propaganda and Misinformation” vs. “Propaganda & Misinformation”)

Given two records with following titles:
Instance 1 title == "Propaganda and Misinformation"
Instance 2 title == "Propaganda & Misinformation"

Stories:

  1. Story

    • Login to FOLIO Snapshot, https://folio-snapshot.dev.folio.org/ as diku_admin

    • Go to Inventory app and select the Instance segment

    • Select the title search option

    • When searching: 'Propaganda and Misinformation'

    • Then you get both titles:

      • Instance 1 title == "Propaganda and Misinformation"

      • Instance 2 title == "Propaganda & Misinformation"

  2. Story

    • Clear all searching, and then again select the title search option

    • When searching: 'Propaganda & Misinformation'

    • Then you get both titles:

      • Instance 1 title == "Propaganda and Misinformation"

      • Instance 2 title == "Propaganda & Misinformation"

Test in MG bf environment:
Test setup:

  1. Instance with title Build & construct LAMA

  2. Instance with title Build and construct LAMA

And here the searches, their result and my expectations:

Index

Search terms

Actual results

Expected results

Title (all)

build construct lama

Instance 1 + 2

Instance 1 + 2

Title (all)

build and construct lama

Instance 2

Instance 1 + 2

Title (all)

build & construct lama

No result

Instance 1 + 2

Environment

None

Potential Workaround

None

CSP Request Details

None

CSP Rejection Details

None

CSP Approved

None

Attachments

5
  • 21 Nov 2022, 02:30 PM
  • 21 Nov 2022, 02:30 PM
  • 21 Nov 2022, 02:30 PM
  • 21 Nov 2022, 02:28 PM
  • 18 Sep 2020, 12:13 PM

Confluence content

mentioned on

Checklist

hide

TestRail: Results

Activity

Show:

Pavlo Smahin March 10, 2025 at 12:49 PM

, seems that this is already implemented. Please check if we still need the story.

Jenn Colt January 6, 2023 at 7:40 PM

Encountered this in my work this week. Shouldn't affected institution be all?

Charlotte Whitt November 21, 2022 at 2:30 PM

- this ticket was original written up when we did search by using postgreSQL.

In Lotus, it looks like it works because there is a Variant Title Cataloging and classification quarterly:

Also I notice, that now in Nolana, then Keyword search on this title with an '&' does not work:

Michelle Suranofsky November 18, 2022 at 9:31 PM

Charlotte Whitt November 1, 2022 at 3:25 PM

Hi - I understand. Thanks for trying.

Details

Assignee

Reporter

Tester Assignee

Priority

Story Points

Development Team

Spitfire

Release

Not Scheduled

Affected Institution

!!!ALL!!!

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 18, 2020 at 12:12 PM
Updated March 10, 2025 at 12:49 PM
TestRail: Cases
TestRail: Runs

Flag notifications