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

    Search for items without call number

    • Product: Aleph
    • Product Version: 22
    • Relevant for Installation Type: select the relevant: Dedicated-Direct,Direct,Local,Total Care

    Question

    Is it possible to search for all items that have an empty call number field?

    Answer

    Unfortunately there is no Aleph service or search functionality allowing the requested search. This could only be done with SQL and the following request:

    select z30_rec_key from z30 where z30_call_no is null; 

    Additional Information

    Insert additional information content here, if there is no content please delete the header for this section

    Attachment

    If there is an attachment add link to the attachment according to steps below, if there is no content please delete the header for this section

     

    • Was this article helpful?