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

[Mike Rylander]

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
https://equinoxOLI.org


On Thu, Aug 31, 2023 at 5:05 PM Brian Holda via Evergreen-dev <
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
>
> <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
>
> <https://library.calvin.edu/>
>
>
> _______________________________________________
> Evergreen-dev mailing list
> Evergreen-dev at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/4b9d75a9/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-eud3b2gl.png
Type: image/png
Size: 5783 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/4b9d75a9/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-te3kg1mr.png
Type: image/png
Size: 5783 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/4b9d75a9/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-eud3b2gl.png
Type: image/png
Size: 5783 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20230831/4b9d75a9/attachment-0005.png>