> 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" <[email protected]> > To: "Evergreen Development Discussion List" > <[email protected]> > 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 <[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 > > > > > -- Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 [email protected] http://pines.georgialibraries.org/
