[Koha] OPAC Search Report

schnydszch eugenegf at yahoo.com
Fri Nov 24 04:05:39 NZDT 2017


Hi! Looking at the database schema of Koha ILS and Koha mysql report
https://wiki.koha-community.org/wiki/SQL_Reports_Library, you can use this
report:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Searches,
the mysql code below:

SELECT COUNT(*) AS Count,
       RIGHT(
              query_desc, 
              Length(query_desc) - Instr(query_desc, ':')
       ) AS 'Search string'
FROM   search_history
GROUP  BY RIGHT(query_desc, Length(query_desc) - Instr(query_desc, ':'))
ORDER  BY COUNT(*) DESC

Mabuhay and HTH!



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html


More information about the Koha mailing list