Hi Mary

A 'claims returned' item will have data in the action.circulation table in the following columns.

husk=# select stop_fines,stop_fines_time from action.circulation where stop_fines like 'CL%' limit 1;
   stop_fines   |    stop_fines_time
----------------+------------------------
 CLAIMSRETURNED | 2009-06-24 00:00:00-07


Mark

Quoting Thomas Berezansky <[email protected]>:

Haven't looked, but I think that is a stopfines reason.

Thomas Berezansky
Merrimack Valley Library Consortium


Quoting Mary Toma <[email protected]>:

We would like to have a list of items that are marked "claims returned" but
I do not know where to begin to create a list.  It is not an item status so
where should I go to create a report of what we want?

Please note new email address:  [email protected]

Mary Toma
South Central Regional Library
160 Main Street
Box 1540
Winkler, MB R6W 4B4
204-325-5864
204-822-4092
[email protected]






Reply via email to