3 SELECT evergreen.upgrade_deps_block_check('1086', :eg_version);
5 CREATE OR REPLACE FUNCTION asset.location_group_default () RETURNS TEXT AS $f$
6 SELECT '!()'::TEXT; -- For now, as there's no way to cause a location group to hide all copies.
8 SELECT '!(' || ARRAY_TO_STRING(ARRAY_AGG(search.calculate_visibility_attribute(id, 'location_group')),'|') || ')'
9 FROM asset.copy_location_group
10 WHERE NOT opac_visible;
12 $f$ LANGUAGE SQL IMMUTABLE;