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

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

    • 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