ALEPH, Sort of

1
ALEPH, Sort of

• Jane Aitkens
• Associate Systems Librarian
• McGill University Libraries
• June 4, 2001 - NAAUG

2
The Problem

• A web user wants to re-sort the records in the
  brief view by the author column - the results are
  ???
• You do a call number search in the GUI OPAC,
  select multiple records, and click Brief. The
  selected records in the Brief View do not remain
  in call number order.

3
The Solution

• Run p_manage_27 to create a sort index for the
  fields displayed in the brief lists columns, so
  the users re-sort request works.
• Assign a specific sort to each type of browse
  search to establish the default sort of the
  results so call number searches stay in call
  number order.

4
Sorting Objectives

• To sort the browse (headings) search results
  appropriately
• To re-sort keyword sets appropriately
• Both in the Web and the GUI
• BIB and AUT searches as well as Course Reserves

5
Tables/Files Involved

• tab_sort
• tab01 tab_filing (maybe)
• tab_expand (maybe)
• www_tab_short.eng
• pc_tab_short.eng
• pc_server_defaults
• www_server_defaults
• www_sort_heading.eng
• pc_tab_sear.eng

6
Which libraries?

• in MGU01 for BIB Indexes
• in MGU10 etc., for AUT Indexes
• in MGU30 for Course Reserves Indexes

7
pc_tab_short.eng
8
www_tab_short.eng
9
tab_sort

• This table assigns sort numbers to the fields
  that are used in your brief views.

10
www_tab_short.eng - Reserves
11
tab_sort - Reserves
12
sorting in the authorities libraries

• The pc_tab_short for EXU10, EXU11, etc.
• L Established Heading 1
  
• L See Also Reference 5
• L Use Codes 008
• A very simple tab_sort 01 1

13
tab_01 and tab_filing

• ! The tab01 table is used for
• ! - defining filing procedure for sort keys based
  on field
• ! (Z101 table, p_ret_21 (sort of retrieved BIB
  records))
• D PSTS 24 00 0000 PSTS Llocation
• Filing procedure 24 in tab_filing
• ! Call numbers
• !
• 24 del_subfield
• 24 to_blank ()-ltgt?,./
• 24 lc_call_no

14
tab_expand

• McGills 12.3 tab_expand for MGU01
• ! SORT-DOC - b_manage_27_a - create
  sort keys
• ! update_sort_doc -
  internal program
• SORT-DOC expand_doc_bib_loc_usm
• throughout , PST could be replaced by LOC, if you
  are using that.
• SORT-DOC expand_doc_bib_loc_usm
• NOTE use newer PST or LOC expand for subfield
  sensitivity (e.g. hi but not k (folio))

15
p_manage_27 - batch index job

• It needs to be re-run if you change tab_sort or a
  filing routine using by one of your sorted
  fields.
• Creates the oracle table Z101
• McGills BIB (4 sort keys, one a PSTS expand)
  took 7 hours to run (12.3)
• Ue_01 updates this index.

16
Z101- MGU01 - sort keys 1 2

• 02 z101_rec_key \
• 03 doc_number ...000951094
• 03 sort_key .....01
• 02 z101_data \
• 03 alpha ........L
• 03 text .........1970
• 02 z101_rec_key \
• 03 doc_number ...000951094
• 03 sort_key .....02
• 02 z101_data \
• 03 alpha ........L
• 03 text .........schuerger james

17
Z101 - MGU01 - sort keys 3 4

• 02 z101_rec_key \
• 03 doc_number ...000951094
• 03 sort_key .....03
• 02 z101_data \
• 03 alpha ........L
• 03 text .........counseling for college
  choice
• 02 z101_rec_key \
• 03 doc_number ...000951094
• 03 sort_key .....04
• 02 z101_data \
• 03 alpha ........L
• 03 text .........lb2342 s38

18
www_server_defaults

• setenv www_sort_field "01---D02---A"
• setenv www_sort_field_ath "03---A01---D"
• setenv www_sort_field_aut "03---A01---D"
• setenv www_sort_field_sub "01---D02---A"
• setenv www_sort_field_crn "03---A01---D"
• setenv www_sort_field_cou "03---A01---D"
• setenv www_sort_field_coi "03---A01---D"
• setenv www_sort_field_inc "03---A01---D"
• setenv www_sort_field_ins "03---A01---D"
• setenv www_sort_field_dep "03---A01---D"

19
pc_server_defaults

• setenv pc_sort_field "01 D02 A"
• setenv pc_sort_field_aut "03 A01 D"
• setenv pc_sort_field_ath "03 A01 D"
• setenv pc_sort_field_lca "04 A03 A"
• setenv pc_sort_field_shl "04 A03 A"
• setenv pc_sort_field_ttl "02 A01 D"
• setenv pc_sort_field_srs "03 A01 D"
• setenv pc_sort_field_trt "03 A01 D"
• setenv pc_sort_field_awt "03 A01 D"
• setenv pc_sort_field_pla "02 A01 D"
• setenv pc_sort_field_all "01 A02 A"
• setenv pc_sort_field_nam "01 A02 A"
• setenv pc_sort_field_top "01 A02 A"
• setenv pc_sort_field_geo "01 A02 A"
• setenv pc_sort_field_lcn "01 A02 A"

20
www_sort_heading.eng

• Used on the brief record screen
  (short_include-3), to describe how the keyword
  set has been (re)sorted
• 01---D03---D Year, then Title
• 01---D02---A Year (latest first), then Author
• 02---A01---D Author, then Year (latest first)
• 02---A03---A Author, then Title
• 03---A01---D Title, then Year (latest first)
• 04---A02---A Call Number, then Author

21
pc_tab_sear

• On the brief record screen, the Sort button
• SO MGU01 L Year 01
• SO MGU01 L Call number 04
• SO MGU01 L Author 02
• SO MGU01 L Title 03
• Different for the authority library
• SO MGU10 L Heading 01

22
In Summary

• Based on your short views, assign sort key
  numbers
• special filing? tab01 tab_filing
• expanded fields? tab_expand SORT-DOC
• p_manage_27
• assign/describe default sorts, re-sorts
• take a vacation before you start into item
  sorting!