[Koha] SQL help

[Michael Sutherland]

Kerrie,

Which version of Koha are you running? You would likely need to modify the
following report found on the Koha Reports Library
<https://wiki.koha-community.org/wiki/SQL_Reports_Library> to meet your
need.

https://wiki.koha-community.org/wiki/SQL_Reports_Library#Zero_Results_Searches

M.
_________________________________________
*Michael J. Sutherland*
University Libraries
Virginia Tech
sudrland at vt.edu | 540.231.9669 <+15402319669>



On Tue, Dec 10, 2019 at 11:57 PM Kerrie Stevens <kerrie.stevens at ac.edu.au>
wrote:

> ‘Unsuccessful’ would be a search where no search results were returned.
> ‘Successful’ would be searches that retrieved results
> Thanks,
>
>
> Kerrie Stevens
>
>
> From: Coehoorn, Joel <jcoehoorn at york.edu>
> Sent: Wednesday, 11 December 2019 3:54 PM
> To: Kerrie Stevens <kerrie.stevens at ac.edu.au>
> Subject: Re: [Koha] SQL help
>
> Define "unsuccessful"
>
> On Tue, Dec 10, 2019, 10:13 PM Kerrie Stevens <kerrie.stevens at ac.edu.au
> <mailto:kerrie.stevens at ac.edu.au>> wrote:
> Our overall library collection is currently split between 2 different
> catalogues. The other catalogue can produce a report showing the number of
> opac searches (total, successful and unsuccessful) for each day of each
> month for the year. Can anyone help with how I can replicate that in Koha?
>
> Thank you,
>
> Kerrie Stevens
> Alphacrucis College
> Melbourne, Australia
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>