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

    Statistics on OPAC Phrase Searching

    • 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