<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
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;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.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]-->
</head>
<body lang="EN-CA" link="blue" vlink="purple" style="word-wrap:break-word">
<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 lang="EN-US" style="font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:#595959"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">Chris Bocchinfuso,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">Library Facilitator: user experience<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">Welland Campus Library, SE 206<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">905 735 2211, e. 7731<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif"><a href="mailto:cbocchinfuso@niagaracollege.ca"><span style="color:#0563C1">cbocchinfuso@niagaracollege.ca</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif"><a href="https://nclibraries.niagaracollege.ca/library"><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"><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 lang="EN-US" style="font-family:"Segoe UI",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Segoe UI",sans-serif">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 <evergreen-reports-bounces@list.evergreen-ils.org>
<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 <evergreen-reports@list.evergreen-ils.org><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" border="0" cellspacing="0" cellpadding="0" width="0" style="width:0cm;border-collapse:collapse">
<tbody>
<tr style="height:15.75pt">
<td valign="bottom" style="border:solid #CCCCCC 1.0pt;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Source<o:p></o:p></span></p>
</td>
<td valign="bottom" style="border:solid #CCCCCC 1.0pt;border-left:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Field<o:p></o:p></span></p>
</td>
<td valign="bottom" style="border:solid #CCCCCC 1.0pt;border-left:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
<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 valign="bottom" style="border:solid #CCCCCC 1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
</td>
<td valign="bottom" 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">
</td>
<td valign="bottom" 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">
</td>
</tr>
<tr style="height:15.75pt">
<td valign="bottom" style="border:solid #CCCCCC 1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Bibliographic Records<o:p></o:p></span></p>
</td>
<td valign="bottom" 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">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Is deleted?<o:p></o:p></span></p>
</td>
<td valign="bottom" 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">
<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 valign="bottom" style="border:solid #CCCCCC 1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
</td>
<td valign="bottom" 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">
</td>
<td valign="bottom" 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">
</td>
</tr>
<tr style="height:15.75pt">
<td valign="bottom" style="border:solid #CCCCCC 1.0pt;border-top:none;padding:1.5pt 2.25pt 1.5pt 2.25pt;height:15.75pt;overflow:hidden">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Call Numbers<o:p></o:p></span></p>
</td>
<td valign="bottom" 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">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">ID<o:p></o:p></span></p>
</td>
<td valign="bottom" 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">
<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">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">
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 lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">Chris Bocchinfuso,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">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 lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">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 lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif">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 lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif"><a href="mailto:cbocchinfuso@niagaracollege.ca" target="_blank">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 lang="EN-US" style="font-size:12.0pt;font-family:"Segoe UI",sans-serif"><a href="https://nclibraries.niagaracollege.ca/library" target="_blank">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">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 lang="EN-US" 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 lang="EN-US" style="font-family:"Segoe UI",sans-serif">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">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" target="_blank">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>
</body>
</html>