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: [email protected] personal: [email protected] https://equinoxOLI.org On Thu, Aug 31, 2023 at 5:05 PM Brian Holda via Evergreen-dev < [email protected]> 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 > > <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 > > <https://library.calvin.edu/> > > > _______________________________________________ > Evergreen-dev mailing list > [email protected] > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev >
_______________________________________________ Evergreen-dev mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
