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

[Peters, Michael]

SOMEONE has that level of access.  Who is your database administrator?  They will be the best ones to help you with this problem.

Sincerely, 
Michael Peters 
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128 
email - mrpeters at library.in.gov 


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Robert Heller
Sent: Tuesday, October 02, 2012 2:56 PM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Checked in or Checked out?

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