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

[Brian Holda]

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>
Sent: Thursday, August 31, 2023 4:53 PM
To: Evergreen Development Discussion List <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/>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/e97b7c24/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-eud3b2gl.png
Type: image/png
Size: 5783 bytes
Desc: Outlook-eud3b2gl.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/e97b7c24/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-te3kg1mr.png
Type: image/png
Size: 5783 bytes
Desc: Outlook-te3kg1mr.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/e97b7c24/attachment-0003.png>