Fwd: Question about database fields
*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
participants (3)
-
Jennifer Weston -
Terran McCanna -
Tony Miller