Stuart, They're stored in the table called action.hold_request_cancel_cause:
=# select * from action.hold_request_cancel_cause; id | label ----+----------------------- 1 | Untargeted expiration 2 | Hold Shelf expiration 3 | Patron via phone 4 | Patron in person 5 | Staff forced 6 | Patron via OPAC 7 | Patron via SIP (7 rows) >From a recent stock load. HTH, -- Mike Rylander | President | Equinox Software, Inc. / Open Your Library | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com On Wed, Jul 27, 2016 at 1:09 PM, Forrest, Stuart <[email protected]> wrote: > Beth > > > > Thanks, that is what I was missing. Where can I get a list of all the > possible values for this field? > > > > Thanks > > Stuart > > > > ================================================================================ > > Stuart Forrest PhD > > Library Systems Specialist > > Beaufort County Library > > 843 255 6450 > > [email protected] > > > > http://www.beaufortcountylibrary.org > > > > For Leisure, For Learning, For Life > > > > > > > > From: Open-ils-general > [mailto:[email protected]] On Behalf Of > Willis, Beth > Sent: Wednesday, July 27, 2016 12:57 PM > To: Evergreen Discussion Group > Subject: Re: [OPEN-ILS-GENERAL] Reports > > > > Hi, > > > > Change the value for the "Cause ID" filter to 5 to limit to "Staff forced" > holds. > > > > On Tue, Jul 26, 2016 at 5:35 PM, Justin Bryant > <[email protected]> wrote: > > I attached two screenshots, let me know if you need any more! > > > > On 2016-07-26 4:25 pm, Elizabeth Davis wrote: > > Hello Justin, > > I would love to see this template you are referring to. Would you be > able to share it either via screenshots or a documentation of it? > > Thanks! > > Elizabeth Davis > Head of Digital Services > Scranton Public Library > 500 Vine Street > Scranton, PA 18509 > 570-348-3000 ext. 3050 > [email protected] > > > > -----Original Message----- > From: Open-ils-general > [mailto:[email protected]] On Behalf > Of Justin Bryant > Sent: Tuesday, July 26, 2016 2:11 PM > To: Evergreen Discussion Group <[email protected]> > Subject: Re: [OPEN-ILS-GENERAL] Reports > > This isn't a complete solution, but maybe it'll put you closer. > > If you go to SCLENDS shared folder, and Circulation, there's a report > template called "List of Patron Cancelled holds on Holds Shelf". This > report can be used to show items not on the Hold Shelf too. If you > clone the report and go to base filters, it has the 'Cause ID' as "6". > If you can determine what number equals staff cancellation, you'll > have your report. I've no idea which number that'd be tho'. > > On 2016-07-26 11:15, Forrest, Stuart wrote: > > Hi > > Does anyone know of a report I can use to list all of the holds > cancelled by staff in a certain period? > > Thanks > > Stuart > > ====================================================================== > ========== > > > Stuart Forrest PhD > > Library Systems Specialist > > Beaufort County Library > > 843 255 6450 > > [email protected] > > http://www.beaufortcountylibrary.org [1] > > For Leisure, For Learning, For Life > > > > Links: > ------ > [1] http://www.beaufortcountylibrary.org/ > > > > > > -- > > Beth Willis > Digital & Catalog Librarian > NOBLE, Inc. > 26 Cherry Hill Drive > Danvers, MA 01923
