From 2d84b1449580992f6eac0e9af09114da5a43552a 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 --- Open-ILS/src/eg2/src/app/staff/share/holds/grid.component.html | 1 + .../src/perlmods/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 b25a4465dd..c9bee54876 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 @@ -188,6 +188,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 7f1d95c82e..80ebc0faf7 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.11.0