Robert,
I would do this in the database:
select * from action.circulation
where usr in (
select usr
from actor.card
where barcode = '[user barcode]'
)
and target_copy in (
select id
from asset.copy
where barcode = '[item barcode]'
);
That way you could rule out 'duplicate' circulations.
Hope that helps!
Chris
----- Original Message -----
> From: "Robert Heller" <[email protected]>
> To: "Evergreen Development Discussion List"
> <[email protected]>
> Sent: Tuesday, October 2, 2012 2:16:49 PM
> Subject: Re: [OPEN-ILS-DEV] Checked in or Checked out?
>
> At Tue, 02 Oct 2012 14:05:10 -0400 Evergreen Development Discussion
> List <[email protected]> wrote:
>
> >
> > Quoting Robert Heller <[email protected]>:
> >
> > > We are having an intermitten problem where items get checked in,
> > > but
> > > still show up as checked out on the patron's record, but checked
> > > in on
> > > the item's status. Is this a known problem?
> >
> > Does the patron owe fines? Have you deleted copies and reused the
> > barcodes?
>
> No fines are owed. I don't know about reused barcodes, but I don't
> believe the barcodes have been reusued. These are items from another
> library, at least in the cases I know about.
>
> >
> >
> > >
> > > --
> > > Robert Heller -- 978-544-6933 / [email protected]
> > > Deepwoods Software -- http://www.deepsoft.com/
> > > () ascii ribbon campaign -- against html e-mail
> > > /\ www.asciiribbon.org -- against proprietary attachments
> > >
> > >
> > >
> > >
> >
> >
> >
>
> --
> Robert Heller -- 978-544-6933 / [email protected]
> Deepwoods Software -- http://www.deepsoft.com/
> () ascii ribbon campaign -- against html e-mail
> /\ www.asciiribbon.org -- against proprietary attachments
>
>
>
>
--
Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
[email protected]
http://pines.georgialibraries.org/
