Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Statistics on OPAC Phrase Searching

    Statistics on OPAC Phrase Searching

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    Is there an Oracle table that maintains the OPAC events on how often the search as phrase or search with quotes has actually been done?

    Resolution:
    The BIB z69 table records Web OPAC searches. The following SQL counts the number of phrase searches:

    SQL-SYS01> select count(*) from z69 where z69_search_query like '%"%';

    Note: This could take quite a while, depending on the size of the Z69.

    Limiting it by date will make it run faster, such as:

    SQL-SYS01> select count(*) from z69 where z69_time_stamp like '200705%' and z69_search_query like '%"%';

    FAQ

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Statistics on deleted items
      • Statistics on order arrivals include deleted arrivals
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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