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

    Statistics on OPAC Phrase Searching

    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    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?

    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 '%"%';


    Additional Information


    • Article last edited: 10/8/2013