search

culibraries / library-reporting

Anything to do with library reporting, mostly but not limited to FOLIO.
0 stars 0 forks source link

948 Deletes Search Report #103

Open arthur-aguilera opened 1 year ago

arthur-aguilera commented 1 year ago

This report finds records that have been marked for deletion in the 948 marc field.

arthur-aguilera commented 1 year ago

--948 Deletes Search Report SELECT marc.srs_id, marc.instance_hrid, marc.field, marc.sf, marc.CONTENT, inst.title, inst.status_updated_date, inst.discovery_suppress, ihi.holdings_id, ihi.item_id, ihi.holdings_type_name, ihi.acquisition_method FROM folio_source_record.marc__t AS marc LEFT JOIN folio_inventory.instance__t AS inst ON marc.instance_id = inst.id LEFT JOIN folio_derived.items_holdings_instances AS ihi ON ihi.instance_id = inst.id WHERE marc.field = '948' AND marc.CONTENT LIKE '%delete%' AND inst.discovery_suppress = FALSE AND inst.status_updated_date <= '2023-06-06 00:00:00.000 -0600'