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

[Sharp, Chris]

> We don't have that level of access!

You could also use the reports interface for this:

Circulation source; nullability selection disabled
Displayed Fields:
Circulation -> Circ ID (raw data)
Circulation -> Check Out Time (timestamp)
Circulation -> Check In Time (timestamp)

Base Filters:
Circulation -> Circulating Item -> Barcode
Circulation -> Patron -> All Library Cards -> Barcode

(you could tweak this for your particular needs).

In any case, you would still need someone with database access to update the circulation table if the item(s) still won't check in.

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:55:42 PM
> 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
> 
> 
>                                                                                                             
> 

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