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

    What bib records contain an nnn field?


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



    What's the best way to get the titles of bib records which contain a particular tag (such as the 242)?


    Two ways:

    1. Run the ret-01 service; or 

    2. Search the z00r and get the title from the z13:

    SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ z13_rec_key, z13_title from z13 where z13_rec_key in (select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ Z00R_DOC_NUMBER from z00r where Z00R_FIELD_CODE like '242%');

    (Or one could look for the z00r record for this doc number with z00r_field_code '245%'.) 


    • Article last edited: 31-Mar-2016