Search MARC Authorities

Search/Get Authority records for the Authority app (UXPROD-2942)

TO support the Authority app, we need a way to Search and Retrieve MARC Authority records
Need to consider with our search implementation > browse.
User expectations for searching: when searching just for authority records, I need to be able to search the following MARC Authority Format fields: 100 Personal name, 110 Corporate name, 111 Conference name, 130 Uniform or series title, 150 Subject, 151 Geographic place, 155 Genre. I also need to retrieve authority records based on the cross-references, i.e. the 4XX and 5XX versions of all these fields. It is also useful to be able to search on the LCCN (Library of Congress Control number, field 010) and a system identifier, if possible.

Rough Mockup

https://drive.google.com/drive/folders/10rO1B48TZSLgR3z_E_u8SgBLWI7D_DRx?usp=sharing

NFRs

These results need to return via the UI.

#of results returned	time to retrieve all results AND display results*
1 million	3 seconds
1 - 3 million	5 seconds
3 - 5 million	8 seconds
5 - 10 million	10 seconds
10 - 15 million	12 seconds

*Assumption: We can retrieve within these times BUT display will be supported with pagination meaning we will retrieve AND be able to get enough Authority records for UI display

See first tab for number of Authority records has per library: https://docs.google.com/spreadsheets/d/10GiFrfZee8aY8PcE0JJxf-lWtMkddFWnOYo_tiKYXrs/edit#gid=1474082758

Additional NFRs

Results should be paginated
Offset and limit parameters will determine pagination
Results should contain a JSON response with keys: records (array of associated instance UUIDS), recordCount (integer)
A search with no results should have an empty records array and count of 0

General Functional Requirements

Similar to MODSOURMAN-396 - Getting issue details... STATUS with exceptions in red

General requirements	Phase 1 (Critical)	Phase 2	Phase 3
Allows the user to do a left-anchored search of the data in specified subfields - may address the browse results request.
Allows the user to query the indicator values in specified fields
Allows the user to query control fields, including the leader, by position [ MODSOURCE-257 - Getting issue details... STATUS ]
Allows the user to query by date range fields that contain date values [ MODSOURCE-256 - Getting issue details... STATUS ]
Allows the user to search for the presence or absence of a given field, subfield, or indicator [ MODSOURCE-265 - Getting issue details... STATUS ]
Allows the user to perform NOT searches
The search is exposed via requests to an API endpoint
~~By default the search returns only records that are not suppressed from discovery~~
Ability to search multiple fields (OR'D) and (AND')
Ability to support exact phrase
Ability to support truncation
Ability to support wildcard

List of MARC Authority fields - https://www.loc.gov/marc/authority/ecadlist.html

Keyword Search support - SEARCH these fields

010 LIBRARY OF CONGRESS CONTROL NUMBER | $a - LC control number ; $z
100 - HEADING--PERSONAL NAME | All available subfields with the exception of $6 and $8
110 - HEADING--CORPORATE NAME | All available subfields with the exception of $6 and $8
111 - HEADING--MEETING NAME | All available subfields with the exception of $6 and $8
130 - HEADING--UNIFORM TITLE | All available subfields with the exception of $6 and $8
150 - HEADING--TOPICAL TERM | All available subfields with the exception of $6 and $8
151 - HEADING--GEOGRAPHIC NAME | All available subfields with the exception of $6 and $8
155 - HEADING--GENRE/FORM TERM | All available subfields with the exception of $6 and $8
400 - SEE FROM TRACING--PERSONAL NAME | All available subfields with the exception of $6 and $8
410 - SEE FROM TRACING--CORPORATE NAME | All available subfields with the exception of $6 and $8
411 - SEE FROM TRACING--MEETING NAME | All available subfields with the exception of $6 and $8
430 - SEE FROM TRACING--UNIFORM TITLE | All available subfields with the exception of $6 and $8
450 - SEE FROM TRACING--TOPICAL TERM | All available subfields with the exception of $6 and $8
451 - SEE FROM TRACING--GEOGRAPHIC NAME | All available subfields with the exception of $6 and $8
455 - SEE FROM TRACING--GENRE/FORM TERM | All available subfields with the exception of $6 and $8
500 - SEE ALSO FROM TRACING--PERSONAL NAME | All available subfields with the exception of $6 and $8
510 - SEE ALSO FROM TRACING--CORPORATE NAME | All available subfields with the exception of $6 and $8
511 - SEE ALSO FROM TRACING--MEETING NAME | All available subfields with the exception of $6 and $8
530 - SEE ALSO FROM TRACING--UNIFORM TITLE | All available subfields with the exception of $6 and $8
550 - SEE ALSO FROM TRACING--TOPICAL TERM | All available subfields with the exception of $6 and $8
551 - SEE ALSO FROM TRACING--GEOGRAPHIC NAME | All available subfields with the exception of $6 and $8
555 - SEE ALSO FROM TRACING--GENRE/FORM TERM | All available subfields with the exception of $6 and $8

Fielded search support (In addition to keyword, a user can select a fielded search option from the search dropdown to search specific MARC fields)

Fielded search option	MARC field /subfield	Comments
Personal name	100 - HEADING--PERSONAL NAME \| All available subfields with the exception of $6 and $8 400 - SEE FROM TRACING--PERSONAL NAME \| All available subfields with the exception of $6 and $8 500 - SEE ALSO FROM TRACING--PERSONAL NAME \| All available subfields with the exception of $6 and $8	100 - NR 400 - Repeatable 500 - Repeatable
Corporate/Conference Name	110 - HEADING--CORPORATE NAME \| All available subfields with the exception of $6 and $8 111 - HEADING--MEETING NAME \| All available subfields with the exception of $6 and $8 410 - SEE FROM TRACING--CORPORATE NAME \| All available subfields with the exception of $6 and $8 411 - SEE FROM TRACING--MEETING NAME \| All available subfields with the exception of $6 and $8 510 - SEE ALSO FROM TRACING--CORPORATE NAME \| All available subfields with the exception of $6 and $8 511 - SEE ALSO FROM TRACING--MEETING NAME \| All available subfields with the exception of $6 and $8	110 - NR 111 - NR 410 - Repeatable 411 - Repeatable 510 - Repeatable 511 - Repeatable
Uniform or series title	130 - HEADING--UNIFORM TITLE \| All available subfields with the exception of $6 and $8 430 - SEE FROM TRACING--UNIFORM TITLE \| All available subfields with the exception of $6 and $8 530 - SEE ALSO FROM TRACING--UNIFORM TITLE \| All available subfields with the exception of $6 and $8	130 - NR 430 - Repeatable 530 - Repeatable
Subject	150 - HEADING--TOPICAL TERM \| All available subfields with the exception of $6 and $8 450 - SEE FROM TRACING--TOPICAL TERM \| All available subfields with the exception of $6 and $8 550 - SEE ALSO FROM TRACING--TOPICAL TERM \|All available subfields with the exception of $6 and $8	150 - NR 450 - Repeatable 550 - Repeatable
Children's subject headings	008 position [11] value [b]	008 - NR
Geographic place	151 - HEADING--GEOGRAPHIC NAME \| All available subfields All available subfields with the exception of $6 and $8 451 - SEE FROM TRACING--GEOGRAPHIC NAME \| All available subfields with the exception of $6 and $8 551 - SEE ALSO FROM TRACING--GEOGRAPHIC NAME \| All available subfields with the exception of $6 and $8	151 - NR 451 - Repeatable 551 - Repeatable
Genre	155 - HEADING--GENRE/FORM TERM \| All available subfields with the exception of $6 and $8 455 - SEE FROM TRACING--GENRE/FORM TERM \| All available subfields with the exception of $6 and $8 555 - SEE ALSO FROM TRACING--GENRE/FORM TERM \| All available subfields with the exception of $6 and $8	155 - NR 455 - Repeatable 555 - Repeatable
Identifier - all	001 - Control Number 010 LIBRARY OF CONGRESS CONTROL NUMBER \| $a - LC control number ; $z 024 - OTHER STANDARD IDENTIFIER \| All available subfields with the exception of $6 and $8 035 - SYSTEM CONTROL NUMBER \| $a - System control number ; $z	001 - NR 010 - NR 024 - Repeatable 035 - Repeatable
Authority UUID	999 ff $s	NR
Notes	667 - NONPUBLIC GENERAL NOTE \| $a	667 - Repeatable

Filters

MARC field/subfield	MARC field /subfield	Input type
Record Created by	040 - CATALOGING SOURCE \| $a	Multi-select
Record Updated by	040 - CATALOGING SOURCE \| $d	Multi-select
Record Creation Date	008 positions 00-05	Date picker filter
Record Last Updated by	005 - DATE AND TIME OF LATEST TRANSACTION	Date picker filter
Include 4XX & 5XX in search results	TBD	Single checkbox

MARC field/subfield	MARC field /subfield	Critical (include initial release)	Comments
Subject heading/thesaurus	008 - FIXED-LENGTH DATA ELEMENTS \| [11] Subject heading system/thesaurus
Authority File - Source	Will not be MARC value - Implementation TBD

Additional details:

From Steven Folsom: In case it's helpful (I think I shared this before), here is a spreadsheet with indexing decisions made by catalogers for searching different authorities in an LD4P work area: https://docs.google.com/spreadsheets/d/1rPvEoP9iYNkxJ0eWC8gXe3ci7e6mhW0da59xkGhadi0/edit#gid=745128104
Feb 2021 User feedback
March 2021 User feedback
June 2021 User feedback
June 2021 use cases: See Rows (8-10)
NFRs