[Koha] OPAC SQL Report Search

Tim McMahon tmcmahon at wlpl.org
Thu Aug 26 03:43:59 NZST 2021


There is a search_history table in the database, but it looks like it 
only logs searches from patrons who are logged in to their account.  
There could be a preference to log anonymous searches, but I didn't find 
it in my search.

On 8/25/21 10:21 AM, Eric Phetteplace wrote:
> I think this would typically be done with website tracking software, like
> Google Analytics or Matomo <https://matomo.org/>.
>
> Best,
>
> ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
>
> ephetteplace at cca.edu | o 510.594.3660 (cca)
>
> 5212 Broadway | Oakland, CA | 94618
>
> CCA is situated on the traditional unceded lands of the Ohlone peoples.
>
> Black-owned bookstores in Oakland: Ashay by the Bay
> <https://ashaybythebay.com/>, Marcus Books
> <https://www.facebook.com/marcus.books/>
>
> :(){ :|: & };:
>
>
> On Wed, Aug 25, 2021 at 7:52 AM Guillermo <guillermo.alexhandr at gmail.com>
> wrote:
>
>> Hi Victor, I checked koha's sql report list and there is nothing like it.
>> I think you should check the access log of the apache server or your
>> installed web server.
>>
>> Ing. Guillermo González
>>
>> El mié., 25 de ago. de 2021 10:19 a. m., Victor Barroso Oliveira <
>> vbovictor at gmail.com> escribió:
>>
>>> Good morning,
>>> Does any member of the group have SQL REPORT which displays the OPAC
>> search
>>> statistics
>>> Thanks
>>> _______________________________________________
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- 
*Tim McMahon*
West Liberty Public Library

319-627-2084



More information about the Koha mailing list