*Forwarding message sent to evergreen-catalogers list - * Welcome, Tessa! Anyone have Reporting suggestions to share? ---------- Forwarded message ---------- From: Tessa Johnson <Tessa.Johnson@thehowe.org> To: "evergreen-catalogers@list.evergreen-ils.org" < evergreen-catalogers@list.evergreen-ils.org> Cc: Bcc: Date: Thu, 13 Mar 2025 16:05:00 +0000 Subject: Question about database fields Hey all, New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them? Thanks, Tessa -------------------------------- *Tessa Johnson* (she/her) *Collection Development & Systems Manager* Howe Library www.thehowe.org *Currently Reading <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=reading_link&utm_source=email_signature>* [image: Book Cover] <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=cover&utm_source=email_signature> [image: Goodreads Logo] <https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature> *Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a “hanovernh.org <http://hanovernh.org/>” email address, another email address, or another platform/website.*
Here are some documents that may help. I always go to search available templates first. In the Mo. Evergreen system there are several good ones that could cover that. 08. G-Standardized-Report-Columns.pdf <https://drive.google.com/open?id=1-2yU03q0QQGAKRqIQN6vuA3oUxR3rDn2> 07. Evergreen Data Types Handout <https://drive.google.com/open?id=1lkVLBSJEnVI5Pv0UCgF3EkCpRGA6mxwd6FJrXvVrnrQ> On Thu, Mar 13, 2025 at 11:15 AM Jennifer Weston via Evergreen-reports < evergreen-reports@list.evergreen-ils.org> wrote:
*Forwarding message sent to evergreen-catalogers list - * Welcome, Tessa! Anyone have Reporting suggestions to share?
---------- Forwarded message ---------- From: Tessa Johnson <Tessa.Johnson@thehowe.org> To: "evergreen-catalogers@list.evergreen-ils.org" < evergreen-catalogers@list.evergreen-ils.org> Cc: Bcc: Date: Thu, 13 Mar 2025 16:05:00 +0000 Subject: Question about database fields Hey all, New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them?
Thanks, Tessa
-------------------------------- *Tessa Johnson* (she/her) *Collection Development & Systems Manager* Howe Library www.thehowe.org
*Currently Reading <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=reading_link&utm_source=email_signature>* [image: Book Cover] <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=cover&utm_source=email_signature>
[image: Goodreads Logo] <https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature>
*Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a “hanovernh.org <http://hanovernh.org/>” email address, another email address, or another platform/website.*
_______________________________________________ Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org
-- Tony Miller *User Services Coordinator * [image: 01] 318 North Main Street | Poplar Bluff, MO 63901 (573) 686 – 8639 Website <https://poplarbluff.org/> | Newsletter <https://poplarbluff.org/OTS.pdf> | Annual Report <https://poplarbluff.org/annualreport.html> | Digital Library <http://poplarbluff.org/downloads.html> ***Promoting Libraries to Make Our Communities Stronger* Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources.
This is what we use internally: Uses Classic Item List source. Displayed Fields: Classic Item List -> Owning Lib Name as "Owning Library" Classic Item List -> Edit Date as "Last Edit Date Classic Item List -> Shelving Location Name as "Shelving Location" Classic Item List -> Callnumber Label as "Call Number" Classic Item List -> Title Classic Item List -> Author Classic Item List -> Barcode Classic Item List -> TCN Classic Item List -> Circ Modifier Classic Item List -> Price Classic Item List -> Copy ID -> Last Editing User -> OPAC/Staff Client User Name as "Last Editor" Base Filters: Classic Item List -> Deleted (Equals) (True) Classic Item List -> Owning Lib -> Organizational Unit ID (In list) Classic Item List -> Edit Date (Date) (Between) On Thu, Mar 13, 2025 at 12:15 PM Jennifer Weston via Evergreen-reports < evergreen-reports@list.evergreen-ils.org> wrote:
*Forwarding message sent to evergreen-catalogers list - * Welcome, Tessa! Anyone have Reporting suggestions to share?
---------- Forwarded message ---------- From: Tessa Johnson <Tessa.Johnson@thehowe.org> To: "evergreen-catalogers@list.evergreen-ils.org" < evergreen-catalogers@list.evergreen-ils.org> Cc: Bcc: Date: Thu, 13 Mar 2025 16:05:00 +0000 Subject: Question about database fields Hey all, New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them?
Thanks, Tessa
-------------------------------- *Tessa Johnson* (she/her) *Collection Development & Systems Manager* Howe Library www.thehowe.org
*Currently Reading <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=reading_link&utm_source=email_signature>* [image: Book Cover] <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=cover&utm_source=email_signature>
[image: Goodreads Logo] <https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature>
*Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a “hanovernh.org <http://hanovernh.org/>” email address, another email address, or another platform/website.*
_______________________________________________ Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org
I am self-taught and not a techie but I have a lot of fun messing around with the reporting system. For our monthly deleted we use an internal template that was created in 2012 which uses a filter "is deleted = true" and a filter to select the "item --> last edit date/time" with field transform Year + Month so that we can find which items were deleted in a given month. Display fields (core source = Item): Circulation Modifier Title Author Call Number Label Item Barcode Deletion Date (this is the column label but my guess is the field is last edit date/time) Filters: Item/Circulating Library/circ_lib/org_unit/In list/Raw Data Item/Is Deleted/deleted/bool/Equals/Raw Data/t Item/Last Edit Date/Time/edit_date/timestamp/In list/Year + Month I have found that rebuilding old templates from scratch is sometimes impossible because fields have changed or been removed or renamed. If you want a clone of the template, email me and I will share the folder that it is in. Katherine Arendt (she/her) Prince Rupert Public Library 101 6th Avenue West Prince Rupert, BC V8J 1Y9 Phone: 250-627-1345 Prince Rupert Public Library is located on the traditional and unceded territory of the Ts'msyen People. -------- Original Message -------- SUBJECT: [Evergreen-reports] Re: Fwd: Question about database fields DATE: 2025-03-13 09:28 FROM: Terran McCanna via Evergreen-reports <evergreen-reports@list.evergreen-ils.org> TO: Evergreen Community Reports Email List <evergreen-reports@list.evergreen-ils.org> This is what we use internally: Uses Classic Item List source. Displayed Fields: Classic Item List -> Owning Lib Name as "Owning Library" Classic Item List -> Edit Date as "Last Edit Date Classic Item List -> Shelving Location Name as "Shelving Location" Classic Item List -> Callnumber Label as "Call Number" Classic Item List -> Title Classic Item List -> Author Classic Item List -> Barcode Classic Item List -> TCN Classic Item List -> Circ Modifier Classic Item List -> Price Classic Item List -> Copy ID -> Last Editing User -> OPAC/Staff Client User Name as "Last Editor" Base Filters: Classic Item List -> Deleted (Equals) (True) Classic Item List -> Owning Lib -> Organizational Unit ID (In list) Classic Item List -> Edit Date (Date) (Between) On Thu, Mar 13, 2025 at 12:15 PM Jennifer Weston via Evergreen-reports <evergreen-reports@list.evergreen-ils.org> wrote:
_Forwarding message sent to evergreen-catalogers list - _ Welcome, Tessa! Anyone have Reporting suggestions to share?
---------- Forwarded message ---------- From: Tessa Johnson <Tessa.Johnson@thehowe.org> To: "evergreen-catalogers@list.evergreen-ils.org" <evergreen-catalogers@list.evergreen-ils.org> Cc: Bcc: Date: Thu, 13 Mar 2025 16:05:00 +0000 Subject: Question about database fields
Hey all, New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them?
Thanks, Tessa
-------------------------------- Tessa Johnson_ _(she/her) _Collection Development & Systems Manager_ Howe Library www.thehowe.org [1]
Currently Reading [2] [3] [4] _Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a "hanovernh.org [5]" email address, another email address, or another platform/website._
_______________________________________________ Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org
_______________________________________________ Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org Links: ------ [1] http://www.thehowe.org/ [2] https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=reading_link&utm_source=email_signature [3] https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=cover&utm_source=email_signature [4] https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature [5] http://hanovernh.org/
Hi Tessa, "Delete Date/Time" can be found in the data source Last Copy Delete Time - it may be in other sources also, but I don't know. I've been working on reviewing the sources, and my notes for this source is "Lists bib record ids with the date the last copy was deleted. NOTES: appears to only list bibs that were not also deleted. We use the library setting "Retain empty bib records / Retain a bib record even when all attached copies are deleted = False"; maybe useful to find some empty records? More testing needed." FWIW, my complete data sources review notes are viewable here: https://docs.google.com/document/d/1uCtW5IRatODwhOJJvPMeVxb35h63TuNzifUZoFn0.... We are running Evergreen 3.12. More specifically for counting deleted copies, we run a monthly recurring report using the Item data source, filtering by Item > Is Deleted = True and Item > Last Edit Date/Time = Year + Month (plus the owning library and stats cats). Our libraries have been using this report for years, and the numbers seem to align with other counts/staff expectations. Here are screenshots of the template: Display fields [image: image.png] Filters [image: image.png] I hope this helps! Lindsay *Lindsay Stratton* *Integrated Library System Administrator / Systems Librarian* Westchester Library System 570 Taxter Rd., 4th Floor Elmsford, NY 10523 lstratton@wlsmail.org On Thu, Mar 13, 2025 at 12:15 PM Jennifer Weston via Evergreen-reports < evergreen-reports@list.evergreen-ils.org> wrote:
*Forwarding message sent to evergreen-catalogers list - * Welcome, Tessa! Anyone have Reporting suggestions to share?
---------- Forwarded message ---------- From: Tessa Johnson <Tessa.Johnson@thehowe.org> To: "evergreen-catalogers@list.evergreen-ils.org" < evergreen-catalogers@list.evergreen-ils.org> Cc: Bcc: Date: Thu, 13 Mar 2025 16:05:00 +0000 Subject: Question about database fields Hey all, New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them?
Thanks, Tessa
-------------------------------- *Tessa Johnson* (she/her) *Collection Development & Systems Manager* Howe Library www.thehowe.org
*Currently Reading <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=reading_link&utm_source=email_signature>* [image: Book Cover] <https://www.goodreads.com/user/email_signature_destination/9480503?utm_medium=cover&utm_source=email_signature>
[image: Goodreads Logo] <https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature>
*Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a “hanovernh.org <http://hanovernh.org/>” email address, another email address, or another platform/website.*
_______________________________________________ Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org
participants (5)
-
Jennifer Weston -
Katherine Arendt -
Lindsay Stratton -
Terran McCanna -
Tony Miller