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

[Thomas Berezansky]

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 <heller at deepsoft.com>:

> At Tue, 2 Oct 2012 14:23:06 -0400 (EDT) Evergreen Development  
> Discussion List 	<open-ils-dev at list.georgialibraries.org> 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" <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
>> >
>> >
>> >
>> >
>>
>
> --
> 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
>
>
>
>