Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Bib records linked to particular authority record

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Desired Outcome Goal:
    Find all the bib records connected to a particular authority record (-- not just the records linked to a particular heading, but the records linked to *any* of its headings).

    Method 1: Bring up each heading in the xxx01 GUI, go to the # of Docs column, and click on "Show".

    Method 2:

    > s+ xxx01
    > select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ Z02_doc_number from z01, z02 where substr (z02_rec_key,1,9) = z01_acc_sequence and Z01_REC_KEY_4 = 'XXX10' || '000029538';

    <where 'xxx01' is the bib library, 'XXX10' is the authority library, and '000123456' is the authority record number.>

    Category: Cataloging (500)

    • Article last edited: 11/13/2014