From d4891d93a48cbf35c235d461ef7909762751f0e6 Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Tue, 11 Dec 2018 13:18:27 -0500 Subject: [PATCH] LP1808006 - Sitemap generator fix to allow shortname parameter. Signed-off-by: Steven Callender --- 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