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 sudrl...@vt.edu | 540.231.9669 <+15402319669> On Tue, Dec 10, 2019 at 11:57 PM Kerrie Stevens <kerrie.stev...@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 <jcoeho...@york.edu> > Sent: Wednesday, 11 December 2019 3:54 PM > To: Kerrie Stevens <kerrie.stev...@ac.edu.au> > Subject: Re: [Koha] SQL help > > Define "unsuccessful" > > On Tue, Dec 10, 2019, 10:13 PM Kerrie Stevens <kerrie.stev...@ac.edu.au > <mailto:kerrie.stev...@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@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha