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.

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)

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.

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

Currently Reading

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" 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