• 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