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. Knowledge Articles
    4. Is there a single Voyager Prepackaged Access Reports table that has just the 856 links?

    Is there a single Voyager Prepackaged Access Reports table that has just the 856 links?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Is there a single Access table in Prepackaged Reports that has just the 856 links?  ELINK_INDEX will find URLs that exist in many different MARC fields, not just the 856 field.

    Answer

    No, there is no such single Access table.  

    In this situation you can use the ELINK_INDEX table to identify possible BIB records, then include the GetFieldAll BLOB function to show all of the 856 fields.

    The following example query will do that for you.  Please note this is a BLOB function query and can take a very long time to run.  

    SELECT BIB_TEXT.BIB_ID, utf8to16([BIB_TEXT].[TITLE]) AS Title, getfieldall(getbibblob([bib_text].[bib_id]),'856') AS AllBib856 FROM (((ELINK_INDEX INNER JOIN BIB_TEXT ON ELINK_INDEX.RECORD_ID = BIB_TEXT.BIB_ID) INNER JOIN BIB_MFHD ON BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID) INNER JOIN MFHD_MASTER ON BIB_MFHD.MFHD_ID = MFHD_MASTER.MFHD_ID) INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID WHERE (((ELINK_INDEX.RECORD_TYPE)="B")) GROUP BY BIB_TEXT.BIB_ID, utf8to16([BIB_TEXT].[TITLE]), getfieldall(getbibblob([bib_text].[bib_id]),'856');

    Additional Information

    Pro Tip: Instead of using Access Reports, Global Data Change's "Scan Rules" allow you to easily set up scan jobs to look for specific strings in a specific MARC subfield (such as an 856 subfield u). See the Global Data Change User's Guide for more information.

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     


    • Article last edited: 16-Mar-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Is there a process for batch deletion with a MARC record file?
      • Is there a tool that would run sample API calls?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      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