1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 |
diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index e70d5777df..a00c6e41b9 100644
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -755,6 +755,8 @@ $f$ LANGUAGE PLPGSQL;
CREATE OR REPLACE FUNCTION asset.record_has_holdable_copy ( rid BIGINT, ou INT DEFAULT NULL) RETURNS BOOL AS $f$
+DECLARE
+ v_ou INT := COALESCE(ou,(evergreen.org_top()).id);
BEGIN
PERFORM 1
FROM
@@ -769,7 +771,7 @@ BEGIN
AND ccs.holdable = true
AND acp.deleted = false
AND acpl.deleted = false
- AND acp.circ_lib IN (SELECT id FROM actor.org_unit_descendants(COALESCE($2,(SELECT id FROM evergreen.org_top()))))
+ AND acp.circ_lib IN (SELECT id FROM actor.org_unit_descendants(v_ou))
LIMIT 1;
IF FOUND THEN
RETURN true; |