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

    Does the "Voyager Record Counts" report included with Prepackaged Access Reports incorporate suppressed records?

    1. Last updated
    2. Save as PDF
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Does the "Voyager Record Counts" report included with Prepackaged Access Reports count unsuppressed records?

    Answer

    Yes, it does.

    if you want separate counts for suppressed and unsuppressed bibliographic records, you can use this SQL query in Prepackaged Reports:

    SELECT BIB_MASTER.SUPPRESS_IN_OPAC, Count(BIB_MASTER.BIB_ID) AS CountOfBIB_ID
    FROM BIB_MASTER
    GROUP BY BIB_MASTER.SUPPRESS_IN_OPAC;

     

     

    • Article last edited: 15-Feb-2020