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
[email protected]

> 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
>

Reply via email to