<div dir="ltr">Hi Brian,<div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>HTH,</div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">--<br>Mike Rylander<br>Research and Development Manager<br>Equinox Open Library Initiative<br>1-877-OPEN-ILS (673-6457)<br>work: miker@equinoxOLI.org<br><div>personal: <a href="mailto:mrylander@gmail.com" target="_blank">mrylander@gmail.com</a><div><a href="https://equinoxOLI.org" target="_blank">https://equinoxOLI.org</a></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 31, 2023 at 5:05 PM Brian Holda via Evergreen-dev <<a href="mailto:evergreen-dev@list.evergreen-ils.org">evergreen-dev@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-8554890935676295415">




<div dir="ltr">
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Perhaps I answered my own question?</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
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).</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Or please let me know if you know of something different I should do.</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Thanks,</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Brian</div>
<div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div id="m_-8554890935676295415Signature">
<div>
<div>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)">Brian Holda<br>
Library Technology Manager<br>
Hekman Library<br>
Calvin University<br style="box-sizing:border-box">
(616) 526-8673<u></u><u></u></span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)"><a href="https://library.calvin.edu/" target="_blank"><img border="0" width="245" height="34" src="cid:e9c10e02-3bcc-4404-a94f-3f7b3d8d6472"></a><u></u><u></u></span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)"><u></u> <u></u></span></p>
</div>
</div>
</div>
</div>
<div id="m_-8554890935676295415appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="m_-8554890935676295415divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Brian Holda <<a href="mailto:brian.holda@calvin.edu" target="_blank">brian.holda@calvin.edu</a>><br>
<b>Sent:</b> Thursday, August 31, 2023 4:53 PM<br>
<b>To:</b> Evergreen Development Discussion List <<a href="mailto:evergreen-dev@list.evergreen-ils.org" target="_blank">evergreen-dev@list.evergreen-ils.org</a>><br>
<b>Subject:</b> Total Number of Non-Deleted Items</font>
<div> </div>
</div>

<div dir="ltr">
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Hi all,</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
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)?</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Thanks,</div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
Brian</div>
<div>
<div style="font-family:"Calibri Light","Helvetica Light",sans-serif;font-size:16pt;color:rgb(0,0,0)">
<br>
</div>
<div id="m_-8554890935676295415x_Signature">
<div>
<div>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)">Brian Holda<br>
Library Technology Manager<br>
Hekman Library<br>
Calvin University<br style="box-sizing:border-box">
(616) 526-8673</span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)"><a href="https://library.calvin.edu/" target="_blank"><img border="0" width="245" height="34" src="cid:d2516613-e6e1-4595-9f00-e86aaa89a911"></a></span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:Georgia,serif;color:rgb(51,51,51)"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>

_______________________________________________<br>
Evergreen-dev mailing list<br>
<a href="mailto:Evergreen-dev@list.evergreen-ils.org" target="_blank">Evergreen-dev@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</div></blockquote></div>