In Checkin/Item Status and the patron's items out tab turn on the "Copy ID" column.

If the numbers in that column *don't* match even though the barcodes do then they are different copies, and the one checked out is likely deleted.

Thomas Berezansky
Merrimack Valley Library Consortium


Quoting Robert Heller <[email protected]>:

At Tue, 2 Oct 2012 14:23:06 -0400 (EDT) Evergreen Development Discussion List <[email protected]> wrote:


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]'
    );


We don't have that level of access!


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


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






Reply via email to