Request - Create a new search/results interface for parts

[falco-rk]

Help us understand your request (check below):

• new feature or otherwise a good idea to make Arctos even better

Describe what you're trying to do

What
As discussed at Issue meeting on December 4 (Agenda, presentation), create a new search/results interface to support part related functional needs. The new interface should be accessed as a tool (perhaps under Related) from the Catalog Record Search in addition to the Search menu.

From this new tool, users would be able to download:

• Results formatted as one row per part
• Results formatted with all attributes parsed into columns by type
• Results that include select data about the immediate parent part of a part
• See count of parts returned by search

Ideally, results would look something like this parts data view mock up, where:

• part data (orange, columns A-C)
• data based on linked tables (yellow, columns D-G)
• related data (pink headers, columns H-M): data associated with the part via Catalog Record, Locality, Event, etc. The presence/absence of columns in "view and download" are set by users as is done for the Catalog Record search results
• parent part data (purple, columns N-S): for the immediate parent part only and includes partID, part name, and values and metadata for preservation and identifier attribute types
• part attributes (green, columns T-forever): For each part attribute type, one column for values and a second column for metadata formatted as a JSON blob. Data concatenated if multiple instances of the same attribute type exist

Why
Searching for parts within the constraints of the Catalog Record Search is too restrictive. Users could begin here but then need to refine their search with part-specific queries and view the results by part rather than by catalog record. Some users may want to search directly in a parts interface.

Resolving the way to look at and get data from attributes may resolve concerns raised in #9236 and #9235

@happiah-madson @ekrimmel @Jegelewicz @campmlc @KatherineLAnderson @Nicole-Ridgwell-NMMNHS