old-git.evergreen-ils.org Git - evergreen/pines.git/blob

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
   4
   5 DROP VIEW IF EXISTS extend_reporter.copy_count_per_org;
   6
   7
   8 CREATE OR REPLACE VIEW extend_reporter.copy_count_per_org AS
   9  SELECT acn.record AS bibid,
  10     ac.circ_lib,
  11     max(ac.edit_date) AS last_edit_time,
  12     min(ac.deleted::integer) AS has_only_deleted_copies,
  13     count(
  14         CASE
  15             WHEN ac.deleted THEN ac.id
  16             ELSE NULL::bigint
  17         END) AS deleted_count,
  18     count(
  19         CASE
  20             WHEN NOT ac.deleted THEN ac.id
  21             ELSE NULL::bigint
  22         END) AS visible_count,
  23     count(*) AS total_count
  24    FROM asset.call_number acn,
  25     asset.copy ac
  26   WHERE ac.call_number = acn.id
  27   GROUP BY acn.record, ac.circ_lib;
  28
  29
  30 COMMIT;