[OPEN-ILS-GENERAL] Reports

[Mike Rylander]

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:  miker at esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Jul 27, 2016 at 1:09 PM, Forrest, Stuart <sforrest at bcgov.net> 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
>
> sforrest at bcgov.net
>
>
>
> http://www.beaufortcountylibrary.org
>
>
>
> For Leisure, For Learning, For Life
>
>
>
>
>
>
>
> From: Open-ils-general
> [mailto:open-ils-general-bounces at list.georgialibraries.org] 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
> <jbryant at clarendoncountylibrary.com> 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
> edavis at albright.org
>
>
>
> -----Original Message-----
> From: Open-ils-general
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf
> Of Justin Bryant
> Sent: Tuesday, July 26, 2016 2:11 PM
> To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
> 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
>
> sforrest at bcgov.net
>
> 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