[Koha] Statistic with Koha
LAURENT Henri-Damien
henridamien.laurent at biblibre.com
Fri Jul 22 21:50:01 NZST 2011
Le 22/07/2011 11:27, schwitzd a écrit :
> Hi
>
> I'm trying to create some statistics, for example I want to have the number
> of the search done today, I wrote this query.
> select count(time) from search_history where year(time) = year(curdate())
> AND month(time) = month(curdate()) AND DAY(time) = day(curdate());
>
> My problem is... if the user do the login in the opac and then do a search
> the table search_history is updated but if the user do a search without
> login nothing is written in the database.
>
> Any idea?
>
grep search zebra.logs |wc-l
should do the trick.
--
Henri-Damien LAURENT
More information about the Koha
mailing list