[Koha] SQL help

[Kerrie Stevens]

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 <sudrland at vt.edu>
Sent: Thursday, 12 December 2019 12:59 AM
To: Kerrie Stevens <kerrie.stevens at ac.edu.au>
Cc: joel.coehoorn at york.edu; koha at 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
sudrland at vt.edu<mailto:sudrland at vt.edu> | 540.231.9669<tel:+15402319669>



On Tue, Dec 10, 2019 at 11:57 PM Kerrie Stevens <kerrie.stevens at ac.edu.au<mailto: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<mailto:jcoehoorn at york.edu>>
Sent: Wednesday, 11 December 2019 3:54 PM
To: Kerrie Stevens <kerrie.stevens at ac.edu.au<mailto: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><mailto: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><mailto: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<mailto:Koha at lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha