Comment 3 for bug 2015484

Revision history for this message
Josh Stompro (u-launchpad-stompro-org) wrote :

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.

Josh