From 0de1824b27c48cb2d24b6e8b0a5e61711dc74452 Mon Sep 17 00:00:00 2001
From: Steven Callender <stevecallender@esilibrary.com>
Date: Tue, 11 Dec 2018 13:18:27 -0500
Subject: [PATCH] LP1808006 - Sitemap generator fix to allow shortname
parameter.
Signed-off-by: Steven Callender <stevecallender@esilibrary.com>
Signed-off-by: Geoff Sams <gsams@roanoketexas.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
Open-ILS/src/support-scripts/sitemap_generator | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
diff --git a/Open-ILS/src/support-scripts/sitemap_generator b/Open-ILS/src/support-scripts/sitemap_generator
index 1a238f5949..22bdd8f0cf 100755
--- a/Open-ILS/src/support-scripts/sitemap_generator
+++ b/Open-ILS/src/support-scripts/sitemap_generator
@@ -163,7 +163,10 @@ sub get_record_ids {
)
";
if ($aou_id) {
- $q .= " WHERE circ_lib IN (SELECT id FROM copy_orgs)";
+ $q .= "
+ INNER JOIN asset.copy ac ON (vc.target_copy = ac.id)
+ WHERE ac.circ_lib IN (SELECT id FROM copy_orgs)
+ ";
}
$q .= "
UNION
--
2.11.0