[OPEN-ILS-GENERAL] Report for long overdue items?

[Andrew Tillman]

We run a recurring weekly OD report for items between 60 and 90 days
overdue. I do not know of a way to share that report across PINES so I can
tell you what filters are used.

We use the old template creator
for this one:

Template type = circulation

Filters =



    Circulation -> Due Date/Time 				(timestamp): choose a
transform = date ; choose a filter = between


    Circulation -> Circulating Library -> Organizational Unit
ID 				(org_unit): choose a
transform= raw data; choose a filter = in list
    Circulation -> Check In Date/Time 				(timestamp): choose a
transform= raw data; choose a filter = is null

Displays:


    Circulation -> Circulating Library -> Short (Policy)
Name 				(text)
    Circulation -> Due Date/Time 				(timestamp)
    Circulation -> Circulating Item -> Call Number/Volume
-> Call Number Label 				(text)
    Circulation -> Circulating Item -> Call Number/Volume
-> Bib Record -> Simple Record Extracts -> Title Proper
(normalized) 				(text)
    Circulation -> Circulating Item -> Barcode
				(text)

If you need any help or have any questions let me know! In the Evergreen
template you can't specify past 90 days if you use a relative date for
recurring reports, like we do.-- 
Andrew Tillman
Tech
Specialist
Lee County Library
Leesburg, GA 31763
tillman at leecountylibrary.org

> Has anyone created a report
template around items that have been overdue
> for
> a
long period of time that they would be willing to share?  I guess I'm
> trying to do 2 things  - Make a list of people who have items that
are
> more
> than 4 weeks overdue and make a list of
people who have billing totals
> over
> $20.00.
>
Any help with this would much appreciated.
> Cheers, Cynthia
> Mohawk College
> Hamilton, ON
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20100222/2a68044b/attachment.htm