From 8957806738a631ec5630e657abbd0ff750b23df9 Mon Sep 17 00:00:00 2001 From: Dan Briem Date: Wed, 5 Oct 2022 14:52:40 -0400 Subject: [PATCH] LP#1991726 View Holds: Patron Home Library Column Adds a patron home library shortcode column to the staff catalog view holds grid. Signed-off-by: Dan Briem Signed-off-by: Susan Morrison Signed-off-by: Galen Charlton --- Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html | 1 + .../lib/OpenILS/Application/Storage/Publisher/action.pm | 3 +++ 2 files changed, 4 insertions(+) diff --git a/Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html b/Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html index d30526d826..846c219f2b 100644 --- a/Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html +++ b/Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html @@ -214,6 +214,7 @@ + diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm index 9a6c302904..2b1fba28c4 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm @@ -2235,6 +2235,8 @@ SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time sl.shortname AS sl_shortname, + ul.shortname AS ul_shortname, + tr.id AS tr_id, tr.source_send_time AS tr_source_send_time, tr.dest_recv_time AS tr_dest_recv_time, tr.target_copy AS tr_target_copy, tr.source AS tr_source, tr.dest AS tr_dest, tr.prev_hop AS tr_prev_hop, tr.copy_status AS tr_copy_status, tr.persistant_transfer AS tr_persistant_transfer, @@ -2382,6 +2384,7 @@ SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time JOIN actor.org_unit pl ON (h.pickup_lib = pl.id) JOIN actor.org_unit rl ON (h.request_lib = rl.id) JOIN actor.org_unit sl ON (h.selection_ou = sl.id) + JOIN actor.org_unit ul ON (u.home_ou = ul.id) JOIN t_field ON TRUE JOIN a_field ON TRUE JOIN s_field ON TRUE -- 2.43.2