Page Comparison

Report Description Detail

To extract records for all items that have a permanent location or temporary location that matches the location(s) selected from the location list. This can include item information such as barcode information or not, enumeration, or chronology, instance information such as title and primary contributor, and loan history information. This report can be run ad hoc or on a regular basis.

The model is based on REP-189 and UXPROD-2051.

Start report with:

Instance Discovery Suppress

Item Discovery Suppress

Inventory Item ID

Item Location

Item Call number

Item Call number type

Item Call number Prefix

Item Call number Suffix

Barcode

Title

Author

Year

Enumeration

Chronology

OCLC

ISSN

ISBN

Last Circulation date

CheckoutsDiscovery Suppress to filter out all suppressed records → Holdings Record Discovery Suppress to filter out all suppressed holdings records → Item Discovery Suppress to filter out all item suppressed records → filter by item location and retrieve for the report: instance UUID, instance HRID, title, primary contributor, identifiers in instance such as OCLC, ISBN, ISSN; item barcode, item year, item enumeration, item chronology, item effective call number, item UUID, item HRID; circulation last circulation date and the loan history for that item.

Filters:

Instance Discovery Suppression | Holdings Discovery Suppress | Item Discovery Suppress | Item Location

We want only instances, holdings, and items that are discoverable (ie. not suppressed).

Data fields:

Instance UUID | Instance HRID| Instance ID Values | Instance Title | Instance Primary Contributor | Date instance created | Instance created by user | date instance updated | Instance updated by user |  | Item UUID | Item HRID | Item barcode | Item enumeration | Item chronology | Item year caption | Item effective call number | Item Effective Call number | Item status | Patron IDItem last check in | Item Loan history

SELECT
        l.item_id AS item_id,
        COUNT(DISTINCT l.id) AS count_loans
    FROM
        loans AS l
    GROUP BY l.item_id