[OPEN-ILS-DEV] Checked in or Checked out?

[Sharp, Chris]

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" <heller at deepsoft.com>
> To: "Evergreen Development Discussion List" <open-ils-dev at list.georgialibraries.org>
> 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 	<open-ils-dev at list.georgialibraries.org> wrote:
> 
> > 
> > Quoting Robert Heller <heller at deepsoft.com>:
> > 
> > > 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 / heller at deepsoft.com
> > > Deepwoods Software        -- http://www.deepsoft.com/
> > > ()  ascii ribbon campaign -- against html e-mail
> > > /\  www.asciiribbon.org   -- against proprietary attachments
> > >
> > >
> > >
> > >
> > 
> > 
> > 
> 
> --
> Robert Heller             -- 978-544-6933 / heller at deepsoft.com
> 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
csharp at georgialibraries.org
http://pines.georgialibraries.org/