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