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@dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Bob Birchall Sent: Thursday, 27 June 2019 11:48 PM To: BOUIS Sonia <sonia.bouis@univ-lyon3.fr> Cc: koha@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@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@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 -- Click here to report this message as spam: https://console.mailguard.com.au/ras/1VZWOqYKXe/7ePKoRwH96EihN84rnpCvL/3.3