As an example, I think this should give you a list of all bib records
with visible copies:
SELECT DISTINCT record
FROM asset.copy_vis_attr_cache
WHERE vis_attr_vector @@ (
SELECT c_attrs::query_int
FROM asset.patron_default_visibility_mask()
LIMIT 1
);
If you want to limit yourself to records with copies that are visible at
SYS1, you could pass a list of SYS1 and descendants (2, 4, 5, and 8) to
search.calculate_visibility_attribute_test, like so:
WITH c_attr AS (
SELECT (ARRAY_TO_STRING(ARRAY[
c_attrs,
search.calculate_visibility_attribute_test('circ_lib','{2,4,5,8}',FALSE)
],'&'))::query_int AS vis_test
FROM asset.patron_default_visibility_mask() x
)
SELECT COUNT(DISTINCT vc.record)
FROM asset.copy_vis_attr_cache vc, c_attr
WHERE vc.vis_attr_vector @@ c_attr.vis_test;
These queries don't include records that have located URIs but no
physical copies.
Hope that helps!
Jeff
On 2019-06-06 8:07 a.m., Mike Rylander wrote:
Hi Josh,
The short version is that you'll want to use the output of
asset.patron_default_visibility_mask()'s c_attrs column to test the
vis_attr_vector column of asset.copy_vis_attr_cache for copies
attached to the records in question. It gets more complicated if you
want to check visibility of records at a specific location. You can
look at how the search query does that for more details.
(Short because I have to run, sorry! Hope that pointer is helpful to start.)
--
Mike Rylander
| Executive Director
| Equinox Open Library Initiative
| phone: 1-877-OPEN-ILS (673-6457)
| email: [email protected]
| web: http://equinoxinitiative.org
On Thu, Jun 6, 2019 at 9:23 AM Josh Stompro <[email protected]> wrote:
Hello, I just saw bug #1831803 [1] about removing asset.opac_visible_copies
which jogged my memory that I need to change how our OCLC holdings update
scripts work in the future.
Does anyone know if there is a write up/conference presentation on how the
asset visiblility / biblio.record_entry.vis_attr_vector stuff works? I want to
select all bib records of physical items that show up in the catalog for the
public by default.
Thanks
Josh
1 - https://bugs.launchpad.net/evergreen/+bug/1831803
Lake Agassiz Regional Library - Moorhead MN larl.org
Josh Stompro | Office 218.233.3757 EXT-139
LARL IT Director | Cell 218.790.2110
