Hello, I've been trying this out and I think some bibs are not being excluded.
I'm comparing the list of bibs created with this query
\pset format unaligned
SELECT DISTINCT bre.id
FROM biblio.record_entry AS bre
JOIN asset.call_number AS acn ON acn.record = bre.id and not acn.deleted
join asset.copy_vis_attr_cache acvac on acvac.record=bre.id
and acvac.vis_attr_vector @@ ( SELECT c_attrs::query_int FROM asset.patron_default_visibility_mask() LIMIT 1 )
WHERE bre.deleted='false'
and acn.owning_lib in (SELECT id FROM actor.org_unit_descendants(101)) --101 = LARL
order by 1
and what is exported with the --exclude-hidden --items --descendants LARL arguments.
I'm seeing bibs being included when there is just one copy that has a status that should hidden from the opac. This caused 6346 bibs to be included in the export that are hidden from the opac in our case, out of 125738 total in the marc_export data file.
Hello, I've been trying this out and I think some bibs are not being excluded.
I'm comparing the list of bibs created with this query
\pset format unaligned vis_attr_ cache acvac on acvac.record=bre.id attr_vector @@ ( SELECT c_attrs::query_int FROM asset.patron_ default_ visibility_ mask() LIMIT 1 ) unit_descendant s(101)) --101 = LARL
SELECT DISTINCT bre.id
FROM biblio.record_entry AS bre
JOIN asset.call_number AS acn ON acn.record = bre.id and not acn.deleted
join asset.copy_
and acvac.vis_
WHERE bre.deleted='false'
and acn.owning_lib in (SELECT id FROM actor.org_
order by 1
and what is exported with the --exclude-hidden --items --descendants LARL arguments.
I'm seeing bibs being included when there is just one copy that has a status that should hidden from the opac. This caused 6346 bibs to be included in the export that are hidden from the opac in our case, out of 125738 total in the marc_export data file.
Josh