Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

2017-03-01 Thread Tobin, Jessica L
Hi Vanda, We run this report daily to keep up with holds that are languishing on the pick-up shelves for too long: SELECT biblio.title AS 'title', p.surname, p.firstname AS 'first name', p.email, p.cardnumber AS 'patron barcode', h.waitingdate AS 'hold available date', i.barcode AS 'item

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

2017-03-01 Thread Liz Rea
Hi, In the Koha interface, you can go to Circulation -> Holds awaiting pickup and have a look at the "Hold(s) over" tab. This should show you the information you are wanting. Cheers, Liz Rea Catalyst IT On 01/03/17 23:16, vanda koha wrote: > Hi everybody, > > I would like to run a report that w

[Koha] SQL query to enable all patrons messaging preferences

2017-03-01 Thread Vimal Kumar V.
Dear Jonthan, As per your instructions I run the script. All borrowers messaging preferences set to default messaging preferences of concerned Patron categories. Now its OK. Thank you Liz and Jonathan. Following commands applied. Load environment variables sudo su export PERL5LIB="/usr/share/koh

Re: [Koha] Koha Digest, Vol 136, Issue 40

2017-03-01 Thread Cybermon
Dear All, Hello, Please I am looking SQL Query for librarian circulation reports to Borrower's circulation report by onsite and check-out between "date range" and "by patron category" sorted by day or librarian My reason for the report is: to count served by which librarian how many onsite a

[Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

2017-03-01 Thread vanda koha
Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It w

Re: [Koha] SQL query to enable all patrons messaging preferences

2017-03-01 Thread Jonathan Druart
Did you call it with --doit? See perl misc/maintenance/borrowers-force-messaging-defaults -h On Wed, 1 Mar 2017 at 07:03 Vimal Kumar V. wrote: > Dear Liz, > The script borrowers-force-messaging-defaults did not change the messaging > preferences of patrons already entered. > But default messagin