[Koha] Notify the borrower when a hold is placed

Carlos Lopez clopez at dml.vic.edu.au
Fri Jun 28 12:28:05 NZST 2019


Hi Sonia

We have a report that gives us a list of books that a) have been requested and b) are on loan and due more than 14 days away. The idea is to run this on a daily basis and notify the borrowers who have the books on loan.

----
SELECT distinct CONCAT(borrowers1.surname, ", ", borrowers1.firstname) as "Requesting borrower",
       biblio.author, 
	   biblio.title,
	   CONCAT(borrowers2.surname, ", ", borrowers2.firstname) as "Currently on loan to",
	   issues.date_due as "Due Date"
FROM reserves, items, issues, biblio, borrowers borrowers1, borrowers borrowers2
WHERE reserves.biblionumber = items.biblionumber
AND reserves.borrowernumber = borrowers1.borrowernumber
AND reserves.itemnumber = issues.itemnumber
AND issues.borrowernumber = borrowers2.borrowernumber
AND items.biblionumber = biblio.biblionumber
AND issues.date_due > (SELECT DATE_ADD(CURDATE(), INTERVAL 14 DAY))
ORDER BY borrowers1.surname, borrowers1.firstname

----




With kind regards from the Dalton McCaughey Library Team

Carlos Lopez

Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
Ph: 03 9340 8888 ext.1 | library at dml.vic.edu.au | library.dmlibrary.org.au 

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of Bob Birchall
Sent: Thursday, 27 June 2019 11:48 PM
To: BOUIS Sonia <sonia.bouis at univ-lyon3.fr>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Notify the borrower when a hold is placed

Hi Sonia,
It sounds like you need a recall system.

An attempt has been made:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19532
It looks like its not ready yet.

I hope I've interpreted your question correctly.
Bob Birchall
*CALYX*


On Fri, 28 Jun 2019 at 01:17, BOUIS Sonia <sonia.bouis at univ-lyon3.fr> wrote:

> Hi,
> We would like to allow our university teacher to have very long loan
> period. We would like to notify them when a hold is placed on a book that
> they have checked out.
> Do you know if it's possible ?
> Thanks
>
> Cheers
>
> Sonia BOUIS
> ------------------------------------------------------
> Responsable du Service des applications documentaires
> Bibliothèques universitaires
> Université Jean Moulin Lyon 3
> ADRESSE GÉOGRAPHIQUE > Manufacture des Tabacs | 6 cours Albert Thomas |
> LYON 8e
> ADRESSE POSTALE > Bibliothèque de la Manufacture | 1C avenue des Frères
> Lumière | CS 78242 - 69372 LYON CEDEX 08
>
> Ligne directe : 33 (0)4 78 78 79 03
>
> http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/>| Suivez-nous > Facebook<
> https://www.facebook.com/bulyon3/> | Twitter<https://twitter.com/bulyon3>|
> Instagram<https://www.instagram.com/bu.lyon3/?hl=fr>
> ---------------------------------------------------
> L'Université Jean Moulin est membre de l'Université de Lyon
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> 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
https://lists.katipo.co.nz/mailman/listinfo/koha
-- 

Click here to report this message as spam:
https://console.mailguard.com.au/ras/1VZWOqYKXe/7ePKoRwH96EihN84rnpCvL/3.3



More information about the Koha mailing list