Talis Developer Network - Reservation / Loan SQL/Perl Required - Comments

Hello Have you tried setting

gi06 — Wed, 30 Apr 2008 13:46:10 +0100

Hello
Have you tried setting the TAL_ISSUE_WHEN_RESERVED to No, which should stop borrowers from issuing a reserved item.

reservations and renewals

Brian Crampton — Fri, 18 Apr 2008 17:23:59 +0100

It is possible to get a list from Talis Decisions but it would require joining two queries. One from the Reservation universe and one from the Circulation universe to get both reservation and loan data for items.

I have done a quick experiment on a basic report and it seems to work but there may be some assumptions I've made that don't match your requirements.

However by using a batch script, and I would tend to favour using PERL, you could get messages added to the items automatically as well and this would not be possible in Decisions.

In terms of reporting on all items it is difficult to say without seeing the code but you should be able to get a list of items attached to a reservation by going through the RESERVED_LNK table. For the reservation ids in question you wan the TARGET_IDs where TYPE=0. If using Perl this list of items can be stored in an array and then each item in the array can then be checked for the number of renewals since a specified date.

I realise I'm being a bit vague but without knowing what approach you are taking with your code it is difficult to be be precise. If you want to post the code of your script or send it to me directly I may be able to be more specific.

Thanks

Brian Crampton
Developer, Talis

I've knocked a script

Ian Frost — Thu, 17 Apr 2008 12:19:33 +0100

I've knocked a script together which I think is doing what I require, however when it comes to works with multiple items I only get the barcode of the 1st item, how do I get the script to report all item barcodes?

IT Officer (Systems) @ University of Sunderland

Reservation / Loan SQL/Perl Required

Ian Frost — Thu, 17 Apr 2008 10:43:17 +0100

Here at Sunderland we have enabled the option for students to borrower a reserved item for a week. This in principle is fine however our students, well some of them, have learnt how to abuse this and retain popular items. Using self return they simply return the item and re-issue it, unless spotted by a staff member they can do this for as long as they require the item. An example from yesterday was a reserved item with 8 reservations waiting to be satisfied yet a student had returned and re-issued the items some 5 times prior to a staff member spotting his activities.