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

    Is it possible to search for specific fields using SQL?

    1. Last updated
    2. Save as PDF
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 21

    Question

    Is it possible to search for specific fields using SQL, e.d. edition field 250?

    Answer

    Unfortunately it's not possible to search for the edition field with SQL as the field is contained in the Z00 record with all other fields from the BIB record.

    However you can extract the edition statement using "Retrieve catalog records (p_ret_01,)" e.g. searching for records where field 250 is available or also search for a specific content of field 250. The output file will show system numbers.

    Category: Cataloging (500) - ALEPH

    Subject: ALEPH - 500

    • Article last edited: 9/25/2014