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 <[email protected]> Sent: Thursday, August 31, 2023 4:53 PM To: Evergreen Development Discussion List <[email protected]> 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 [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
