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