‘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

