We have version 18.11.11 and I’ve looked through the reports library but can’t see anything that looks similar to be tweaked into what I need. Thank you,
Kerrie Stevens From: Michael Sutherland <sudrl...@vt.edu> Sent: Thursday, 12 December 2019 12:59 AM To: Kerrie Stevens <kerrie.stev...@ac.edu.au> Cc: joel.coeho...@york.edu; koha@lists.katipo.co.nz Subject: Re: [Koha] SQL help 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<mailto:sudrl...@vt.edu> | 540.231.9669<tel:+15402319669> On Tue, Dec 10, 2019 at 11:57 PM Kerrie Stevens <kerrie.stev...@ac.edu.au<mailto: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<mailto:jcoeho...@york.edu>> Sent: Wednesday, 11 December 2019 3:54 PM To: Kerrie Stevens <kerrie.stev...@ac.edu.au<mailto: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><mailto: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><mailto: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<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
