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

    Custom Reports: Query Reports All Bib Records That Contain an 856 Field

    Created By: Shelley Schultz
    Created on: 5/15/2019



    [This article was copied from the Voyager Wiki.]

    This query will report back on all bib records that contain an 856.

    SELECT BIB_TEXT.TITLE, ELINK_INDEX.LINK_TEXT, ELINK_INDEX.LINK, BIB_TEXT.BIB_ID, ELINK_INDEX.RECORD_TYPE
    FROM ELINK_INDEX INNER JOIN BIB_TEXT ON ELINK_INDEX.RECORD_ID =
    BIB_TEXT.BIB_ID
    GROUP BY BIB_TEXT.TITLE, ELINK_INDEX.LINK_TEXT, ELINK_INDEX.LINK, BIB_TEXT.BIB_ID, ELINK_INDEX.RECORD_TYPE
    HAVING (((ELINK_INDEX.RECORD_TYPE)="B"))
    ORDER BY BIB_TEXT.TITLE;