<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Chris,<br>
<br>
There is also a way to "Report of "Last" Deleted copy"<br>
<br>
Found in the release notes for Evergreen 3.0:<br>
<br>
<a moz-do-not-send="true"
href="https://evergreen-ils.org/documentation/release/RELEASE_NOTES_3_0.html">https://evergreen-ils.org/documentation/release/RELEASE_NOTES_3_0.html</a><br>
<br>
Section:<br>
<h4
id="_new_report_source_table_allowing_report_of_last_deleted_copy">16.10.2.
New Report Source Table Allowing Report of "Last" Deleted copy</h4>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Can consume data in any format
MOBIUS
573-234-4513
877-312-3517</pre>
<div class="moz-cite-prefix">On 6/8/2021 7:44 AM, Christopher
Bocchinfuso wrote:<br>
</div>
<blockquote type="cite"
cite="mid:YQXPR01MB3720A0F78D4ECB3FDC1A08B9C0379@YQXPR01MB3720.CANPRD01.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Segoe UI",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif;mso-fareast-language:EN-US">Hi Beth -
Thank you so much. I will try out this method and see what
happens; it’s a good starting place. I was confused as to
which core source to start, but had Bibliographic Records in
mind.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif;mso-fareast-language:EN-US">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif;mso-fareast-language:EN-US">Chris<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;color:#595959">*Due to the COVID-19
pandemic I am working remotely during virtual library
hours. Emailing me is the best option during this time. To
schedule a call via MS Teams, BB Ultra Collaborate or
Zoom, please send me an email.*</span><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;color:#595959" lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Chris Bocchinfuso,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Library Facilitator:
user experience<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Welland Campus Library,
SE 206<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">905 735 2211, e. 7731<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US"><a
href="mailto:cbocchinfuso@niagaracollege.ca"
moz-do-not-send="true"><span style="color:#0563C1">cbocchinfuso@niagaracollege.ca</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US"><a
href="https://nclibraries.niagaracollege.ca/library"
moz-do-not-send="true"><span style="color:#0563C1">https://nclibraries.niagaracollege.ca/library</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif">*
<a href="https://nclibraries.niagaracollege.ca/library"
moz-do-not-send="true"><span style="color:#0563C1">Virtual
Chat Help</span></a> & Text to Chat 289 802 2275.
*<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif" lang="EN-US">This email contains
confidential information intended for the recipient(s).
Please do not make this information publicly available
without written consent from Niagara College or the
person(s) to whom this email is intended.</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-family:"Segoe
UI",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span
lang="EN-US"> Evergreen-reports
<a class="moz-txt-link-rfc2396E" href="mailto:evergreen-reports-bounces@list.evergreen-ils.org"><evergreen-reports-bounces@list.evergreen-ils.org></a>
<b>On Behalf Of </b>Willis, Beth<br>
<b>Sent:</b> June 7, 2021 3:24 PM<br>
<b>To:</b> Evergreen Community Reports Email List
<a class="moz-txt-link-rfc2396E" href="mailto:evergreen-reports@list.evergreen-ils.org"><evergreen-reports@list.evergreen-ils.org></a><br>
<b>Subject:</b> Re: [Evergreen-reports] Empty
bibliographic records report<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:solid #EBEB34
1.0pt;padding:12.0pt 12.0pt 12.0pt 12.0pt;background:#EBEB34">
<p style="background:#EBEB34;border:none;padding:0cm"><b><span
style="font-size:12.0pt;color:black">ITS Alert: This
email did not originate from the Niagara College email
system.</span></b><span style="color:black">
</span><span style="font-size:10.0pt;color:black">Do not
click links, open attachments or respond unless you
recognize the sender and verify the content is safe.
Please report suspicious emails to the ITS Service Desk
for review.
</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">Hi Chris, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I think I would start with the
Bibliographic Records source and link to the Call
Numbers source and, from there, to the Owning Library to
get the org units.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">In addition to the Org Unit and
(bibliographic record?) date filters I would include
these filters:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<table class="MsoNormalTable"
style="width:0cm;border-collapse:collapse" width="0"
cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr style="height:15.75pt">
<td style="border:solid #CCCCCC 1.0pt;padding:1.5pt
2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Source<o:p></o:p></span></p>
</td>
<td style="border:solid #CCCCCC
1.0pt;border-left:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Field<o:p></o:p></span></p>
</td>
<td style="border:solid #CCCCCC
1.0pt;border-left:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Value<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.75pt">
<td style="border:solid #CCCCCC
1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
</tr>
<tr style="height:15.75pt">
<td style="border:solid #CCCCCC
1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Bibliographic
Records<o:p></o:p></span></p>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Is
deleted?<o:p></o:p></span></p>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">FALSE<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.75pt">
<td style="border:solid #CCCCCC
1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<br>
</td>
</tr>
<tr style="height:15.75pt">
<td style="border:solid #CCCCCC
1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Call
Numbers<o:p></o:p></span></p>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">ID<o:p></o:p></span></p>
</td>
<td
style="border-top:none;border-left:none;border-bottom:solid
#CCCCCC 1.0pt;border-right:solid #CCCCCC
1.0pt;padding:1.5pt 2.25pt 1.5pt
2.25pt;height:15.75pt;overflow:hidden"
valign="bottom">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">is
Null<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I suspect you will want to use a Date
transform for the date field.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I don't actually have a report
template like this, but have attached screenshots of how
I would start off.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I only looked at this quickly, so I
am not certain this will get you the data you are
looking for. It may be a starting place, though.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Beth<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Jun 7, 2021 at 2:44 PM
Christopher Bocchinfuso <<a
href="mailto:cbocchinfuso@niagaracollege.ca"
moz-do-not-send="true">cbocchinfuso@niagaracollege.ca</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC
1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">Hello Evergreen Reports
Group,</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">My library’s cataloguer asked
for a report that generates a list or count of all
our library’s bibliographic records with no
holdings (empty records). We are part of an
Evergreen consortium group called (LiNC) <a
href="https://niagaracollege.niagaraevergreen.ca/eg/opac/home"
target="_blank" moz-do-not-send="true">
Libraries in Niagara Cooperative</a>.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">I only want to filter by
organizational unit and dates for Niagara College
Libraries. I can usually filter things well, but
I’m unsure which Core Source to start with
“bibliographic records” or ‘Item” or “Call
Number/Volume” to get the right data to populate
my fields correctly.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">Does anyone have advice on
how I should approach this? Or perhaps you have a
report template to share with me?</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">I’m an intermediate-level
Evergreen user and I want to expand/continue
learning my reporting tool experience and
knowledge by building template reports.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">Thank you for your help!</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif">Chris
</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:10.0pt;font-family:"Segoe
UI",sans-serif;color:#595959">*Due to the
COVID-19 pandemic I am working remotely during
virtual library hours. Emailing me is the best
option during this time. To schedule a call via MS
Teams, BB Ultra Collaborate or Zoom, please send
me an email.*</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Chris
Bocchinfuso,</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Library
Facilitator: user experience</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">Welland Campus
Library, SE 206</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US">905 735 2211, e.
7731</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US"><a
href="mailto:cbocchinfuso@niagaracollege.ca"
target="_blank" moz-do-not-send="true">cbocchinfuso@niagaracollege.ca</a></span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif" lang="EN-US"><a
href="https://nclibraries.niagaracollege.ca/library"
target="_blank" moz-do-not-send="true">https://nclibraries.niagaracollege.ca/library</a></span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:12.0pt;font-family:"Segoe
UI",sans-serif">*
<a
href="https://nclibraries.niagaracollege.ca/library"
target="_blank" moz-do-not-send="true">Virtual
Chat Help</a> & Text to Chat 289 802 2275. *</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif" lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-family:"Segoe
UI",sans-serif" lang="EN-US">This email
contains confidential information intended for the
recipient(s). Please do not make this information
publicly available without written consent from
Niagara College or the person(s) to whom this
email is intended.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Evergreen-reports mailing list<br>
<a
href="mailto:Evergreen-reports@list.evergreen-ils.org"
target="_blank" moz-do-not-send="true">Evergreen-reports@list.evergreen-ils.org</a><br>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports"
target="_blank" moz-do-not-send="true">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Beth Willis <br>
Digital & Catalog Librarian <br>
NOBLE, Inc. <br>
42 Cherry Hill Drive <br>
Danvers, MA 01923 <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Evergreen-reports mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-reports@list.evergreen-ils.org">Evergreen-reports@list.evergreen-ils.org</a>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a>
</pre>
</blockquote>
<br>
</body>
</html>