Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Custom Reports: Query for BibBlob 650 Subject

    Custom Reports: Query for BibBlob 650 Subject

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Shelley Schultz
    Created on: 5/15/2019



    [This article was copied from the Voyager Wiki.]

    This blob query will give you a report of all bib records and their associated 650 fields.  It dumps all output into a table called "650cleanup".  You can keep this file name or change it to suite your purposes.  You can also modify this blob to gather information from any field in the MARC record you want. When viewing the table you will need to expand the depth of the columns so you can view all subject headings gathered.  In default view you can only see the first line.  By expanding the line height you will be able to view each subject heading collected for an individual bib record.

    SELECT GetFieldAll(GetBibBlob([BIB_ID]),"650") AS FLDDATA, BIB_TEXT.BIB_ID INTO 650fieldCleanUp
    FROM BIB_TEXT
    WHERE (((GetFieldAll(GetBibBlob([BIB_ID]),"650"))<>""));




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Custom Reports: Query by Count of Circ Transaction IDs
      • Custom Reports: Query for Bibliographic Records without MFHD
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Language
      English
      Product
      Voyager
    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