Skip to main content
ExLibris

Knowledge Assistant

BETA
 
Aleph

 

Ex Libris Knowledge Center
  1. Search site
    Go back to previous article
    1. Sign in
      • Sign in
      • Forgot password
  1. Home
  2. Aleph
  3. Knowledge Articles
  4. Finding bib records with multiple occurrences of field

Finding bib records with multiple occurrences of field

  1. Last updated
  2. Save as PDF
  3. Share
    1. Share
    2. Tweet
    3. Share
No headers

 

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

 

Description:
How can I find bib records with multiple 949 fields (or multiple occurrences of some other field)?

 

Resolution:
If you have the z00r, SQL will give you this. Here's a search for multiple 949 fields:

abc01@ALEPH20> select Z00R_DOC_NUMBER from z00r where z00r_field_code like '949%' group by Z00R_DOC_NUMBER having count(*) > 1 order by Z00R_DOC_NUMBER;

 

 


  • Article last edited: 12-Mar-2016
View article in the Exlibris Knowledge Center
  1. Back to top
    • Finding average length of loan and number of items checked out at a time
    • Finding bib records with tag 590
  • Was this article helpful?

Recommended articles

  1. Language
    English
    Product
    Aleph
  2. Tags
    This page has no tags.
  1. © Copyright 2025 Ex Libris Knowledge Center
  2. Powered by CXone Expert ®
  • Term of Use
  • Privacy Policy
  • Contact Us
2025 Ex Libris. All rights reserved