Inventory. Search call number (Core functional) - thin thread

Description

This feature capture the work planned for the Core functional team

The elements Call number, and Call number type are implemented in the Holdings and Item records as of Q4 2018.

Use cases:
Multiple times daily catalogers and other library staff need to search by call number; system needs to search normalized version, not exact text string.

Several libraries have expressed a requirement on being able to search by normalized call number - besides search on call number as an exact string, we'd also need search where we handle removing of misc. qualifiers, and more.

Summary of requirements discussed with SMEs:
So this would be the best solution for the searching of call numbers:

  1. String/phrase index for prefix and call number (no keyword index)

  2. Searching must be possible without spaces and/or special characters

  3. Additionally: exact search (with spaces and special characters)

    • could be customized (per tenant) with a selection list of special characters to be taken into account in a search.

  4. No automatically truncation

    • Wildcards

    • Wildcard for explicitely right truncation, e.g. “*”

    • Wildcard for exact one character, e.g. “!”

  5. Call numbers

    • geo 11

    • geo 12

    • geo 100

    • geo 123

  6. Search variants

    • geo 1! → geo 11 and geo 12

    • geo 1!! → geo 100 and geo 123

    • geo 1* → geo 11 and geo 12 and geo 100 and geo 123

  7. Wildcard for 0-n characters, e.g. “#”

  8. Character classes

    • germ 3[567]0* = germ 350* | germ 360* | germ 370*

  9. Boolean operators, also to combine different search criteria

    • AND

    • OR

    • NOT

Documentation:

  • - - - - - - - - - - - - - - - - - - - - - - -

Examples:
tit=letters per=goethe,*
(Title must contain “letters”, author is Goethe,* ‑ standard operator is AND)
per=bach,j* NOT sgn=mus*
(Author is bach,j*, call number does not start with “mus”)
tit cookbook AND (sgn=math* OR sgn=comp*)
(the cookbook series from O’Reilly)

Some more complex examples from GBV libraries *before *normalization (added by ):

  • 8 G.B.439 :6

  • JUR:R III:54:(1):Schm:1850

  • 94 NF 14/1:3792-3835

  • 1990/146 4°

  • 426/083 4° SH 34

  • Z 557: 54.1961/62,7-12

  • Y 43839 (2017/18)

Priority

Fix versions

Development Team

Prokopovych

Assignee

Solution Architect

Parent Field Value

None

Parent Status

None

Attachments

2
  • 04 Dec 2019, 01:50 PM
  • 04 Dec 2019, 01:50 PM

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte WhittMarch 16, 2020 at 10:06 AM

Okay Check Mark. Done.

Cate BoeremaMarch 16, 2020 at 10:00 AM

can you please remove the two extraneous stories and mark this closed?

Cate BoeremaMarch 2, 2020 at 3:11 PM

Hi I think, if we remove the two stories that are out of scope for Q1, this feature could be moved into In review.

Cate BoeremaFebruary 28, 2020 at 11:45 AM

Hi I think a couple of the stories defining this feature don't belong here anymore (UIIN-857 and UIIN-990). Could you please split those off into another feature for Q2 and rename this one so that it's clear what we decided to do for Q1? That will help us better track when this feature is complete. Thanks!

Cate BoeremaJanuary 30, 2020 at 8:45 AM

This is blocked awaiting the Core Platform work. Marking blocked

Done

Details

Reporter

PO Rank

125

PO Ranking Note

CW: Aligned PO rank with Calculated Total rank

Estimation Notes and Assumptions

Outstanding questions: * Implemented as a search index or as a persisted field containing the normalized version of the call number? * Hard-code normalization rules or configurable?

Analysis Estimate

Small < 3 days

Analysis Estimator

Front End Estimate

Medium < 5 days

Front End Estimator

Front-End Confidence factor

Low

Back End Estimate

Medium < 5 days

Back End Estimator

Rank: FLO (MVP Sum 2020)

R1

Rank: 5Colleges (Full Jul 2021)

R1

Rank: Cornell (Full Sum 2021)

R1

Rank: Chalmers (Impl Aut 2019)

R2

Rank: GBV (MVP Sum 2020)

R2

Rank: hbz (TBD)

R1

Rank: Hungary (MVP End 2020)

R1

Rank: TAMU (MVP Jan 2021)

R1

Rank: Chicago (MVP Sum 2020)

R1

Rank: MO State (MVP June 2020)

R1

Rank: U of AL (MVP Oct 2020)

R1

Rank: Lehigh (MVP Summer 2020)

R1

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created April 17, 2019 at 8:41 AM
Updated September 16, 2020 at 9:13 PM
Resolved March 16, 2020 at 10:07 AM
TestRail: Cases
TestRail: Runs

Flag notifications