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 - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] 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 <[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
