[Evergreen-dev] Total Number of Non-Deleted Items

[Brian Holda]

Thanks, Mike! That is very helpful confirmation to hear 🙂
Brian


Brian Holda
Library Technology Manager
Hekman Library
Calvin University
(616) 526-8673

[cid:c755161b-f074-4599-8bdf-a496ec878001]<https://library.calvin.edu/>



________________________________
From: Mike Rylander <mrylander at gmail.com>
Sent: Thursday, August 31, 2023 6:24 PM
To: Brian Holda <brian.holda at calvin.edu>
Cc: Evergreen Development Discussion List <evergreen-dev at list.evergreen-ils.org>
Subject: Re: [Evergreen-dev] Total Number of Non-Deleted Items

Hi Brian,

You did, in fact, answer your own question!  That's the table that holds item data (that is, barcoded "things" attached to bibliographic records), and deleted=true does mean it's generally ignored by Evergreen except in specific circumstances.

There are nuances, such as non-cataloged items, Located URIs, and conjoined items, that can change the details but if "count of barcoded things" is what you want, that asset.copy is what you need.

HTH,

--
Mike Rylander
Research and Development Manager
Equinox Open Library Initiative
1-877-OPEN-ILS (673-6457)
work: miker at equinoxOLI.org
personal: mrylander at gmail.com<mailto:mrylander at gmail.com>
https://equinoxOLI.org<https://urldefense.proofpoint.com/v2/url?u=https-3A__equinoxOLI.org&d=DwMFaQ&c=4rZ6NPIETe-LE5i2KBR4rw&r=rB3XDC6iCWGkjZtiGXbRHlEfGQP12yvXoVpChsQG6IY&m=4hnR5FRvBjEQcPM5gHlso96YKxgEg4TeHvP5SV1tRy2FGlp12CxQu0-R8otHHoMJ&s=_8saKxirlYzNfDlILGU7Wsi0HzneALRJV-9zqPVntxM&e=>


On Thu, Aug 31, 2023 at 5:05 PM Brian Holda via Evergreen-dev <evergreen-dev at list.evergreen-ils.org<mailto:evergreen-dev at list.evergreen-ils.org>> wrote:
Perhaps I answered my own question?

It seems like using the asset.copy table is probably what I want. Then I can filter out the deleted = true entries (and other things we don't want in the total count).

Or please let me know if you know of something different I should do.

Thanks,
Brian


Brian Holda
Library Technology Manager
Hekman Library
Calvin University
(616) 526-8673

[cid:e9c10e02-3bcc-4404-a94f-3f7b3d8d6472]<https://library.calvin.edu/>



________________________________
From: Brian Holda <brian.holda at calvin.edu<mailto:brian.holda at calvin.edu>>
Sent: Thursday, August 31, 2023 4:53 PM
To: Evergreen Development Discussion List <evergreen-dev at list.evergreen-ils.org<mailto:evergreen-dev at list.evergreen-ils.org>>
Subject: Total Number of Non-Deleted Items

Hi all,

It seems like this would be a simple thing on Evergreen, but I'm a bit at a lost for how to do it. Does anyone know how to get the total number of library items held within the Evergreen database (minus any deletions)?

Thanks,
Brian


Brian Holda
Library Technology Manager
Hekman Library
Calvin University
(616) 526-8673

[cid:d2516613-e6e1-4595-9f00-e86aaa89a911]<https://library.calvin.edu/>



_______________________________________________
Evergreen-dev mailing list
Evergreen-dev at list.evergreen-ils.org<mailto:Evergreen-dev at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev<https://urldefense.proofpoint.com/v2/url?u=http-3A__list.evergreen-2Dils.org_cgi-2Dbin_mailman_listinfo_evergreen-2Ddev&d=DwMFaQ&c=4rZ6NPIETe-LE5i2KBR4rw&r=rB3XDC6iCWGkjZtiGXbRHlEfGQP12yvXoVpChsQG6IY&m=4hnR5FRvBjEQcPM5gHlso96YKxgEg4TeHvP5SV1tRy2FGlp12CxQu0-R8otHHoMJ&s=_7Ll1AjKRionE-NUIPPbBIxbsvHlZgvnTq28AqGTiAE&e=>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230901/1863f933/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-xajl55xu.png
Type: image/png
Size: 5783 bytes
Desc: Outlook-xajl55xu.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230901/1863f933/attachment-0001.png>