Differences

This shows you the differences between two versions of the page.

--- evergreen-reports:sql:auditor [2024/02/07 15:50] – created jventuro
+++ evergreen-reports:sql:auditor [2024/02/07 16:09] (current) – jventuro
@@ Line 77: / Line 77: @@
 **Purpose**: -- Provides a history of edits made to an individual circulation rule.
-**Running Tips/Guidelines**: Replace RULE_ID with the ID of the user from the biblio.record_entry table.
+**Running Tips/Guidelines**: Replace RULE_ID with the ID of the user from the config.circ_matrix_matchpoint.
 <code sql>
@@ Line 87: / Line 87: @@
 where accmmh.id = RULE_ID
 ORDER BY audit_time;
+</code>
+==== Hold Rule History ====
+**Submission Notes:**
+This report was submitted on 2024-02-07 by Jessica Woolford of Bibliomation. It was created by Jessica Woolford
+**Version**:  Used on Evergreen 3.11
+**Data Sources Used**: auditor.hold_matrix_matchpoint_history
+**Purpose**: -- Provides a history of edits made to hold rules for a given owning library and matching circ modifier.
+**Running Tips/Guidelines**: Replace ORG_UNIT with the org unit of the owning library you want to see rules for. Replace CIRC_MOD with the circ modifier or circ modifier part that you want to focus on. Retain the % around it to retrieve a circ mod that contains matching text (for example, all circ modifiers that contain "movie," "dvd," or "book").
+<code sql>
+SELECT * FROM auditor.config_hold_matrix_matchpoint_history WHERE item_owning_ou = ORG_UNIT AND circ_modifier LIKE '%CIRC_MOD%'  ORDER BY audit_time;
 </code>