WIP: Search fields

!147 (merged) @Karna98 @amanbis @amaaniqbal @RoLoDeXx

Simple search

• Query enclosed in %% > like %query%

• Query enclosed in // > /regex/

• Make components for each field search so they can be reused in advanced search

• In id/numbers fields:

  • Find P#, Q# and S# in query, strip to id and add as an additional search criteria (letter + 6 digits > digits without preceding 0 or the letter) eg : P005432 search for P005432 and 5432
  • Test thoroughly to make sure if someone searches for A 321 or A321 they will get OIM A00321 (museum_no) picked up. We can set up test cases for that.

• Keywords >

  • All Publications (see next point)
  • All main entities (eg Collections, Materials, Periods, etc.)
  • IDs and numbers (see below)
  • All artifacts text & varchar fields

• Publications > (restrict to accepted = 1 )

  • publications.designation concatenated with artifacts_publications.exact_reference
  • publications.designation
  • publications.bibtexkey
  • publications.year
  • publications.publisher
  • publications.school
  • publications.series
  • authors.author using authors_publications
  • authors.author using editors_publications
  • publications.title
  • publications.book_title
  • publications.chapter
  • journals.journal from journals_publications

• Collections > Collections.collection through artifacts_collections

• Proveniences > artifacts.written_in and artifacts.provenience_id, Regions.region (back to artifact using proveniences with Proveniences.region_id)

• Periods > Periods.period

• Inscriptions > To discuss

• IDs and numbers artifacts

  • publications.bibtexkey
  • publications.designation concatenated with artifacts_publications.exact_reference
  • publications.designation
  • artifacts.designation
  • artifacts.excavation_no
  • artifacts.composite_no
  • artifacts.museum_no
  • artifacts.seal_no
  • artifacts.excavation_no
  • artifacts.id

Advanced search

Publications

• Keyword > (All pertinent fields)
• Designation > publications.designation
• Author(s) > authors.author using authors_publications
• Editor(s) > authors.author using editors_publications
• Publication year > publications.year
• Title >
  • publications.title
  • publications.book_title
  • publications.chapter
  • journals.journal from journals_publications
• Drop down for cdli publication type (primary, history, etc) (see enum list for field in artifacts_publications)
• Publisher
• Series

Inscriptions data

• Translation >
• Transliteration > To discuss
  • full text or single line search toggle
  • search multiple terms as separate search criteria on semi-colon (eg word1;word2)
• Transcription >
• Annotations >
• Comments >
• Structure >
  divider here
• Genre >
• Language >

Artifact data

• Artifact type >
• Material >
• Collection >
• Provenience >
• Archive >
• Period >
• Artifact comments >

Artifact Identification

• Designation >
• Any identification number >
• Museum Number >
• Accession Number >
• Excavation Number >
• Artifact Number >
• Seal Number >
• Composite Number >

Credits

• Author / Contributor >
• Project >