Contents

select
  (select count(*) from letter_letters where created_at::date = now()::date) as letters_created_today,
  (select count(*) from letter_letters where completed_at::date = now()::date) as letters_printed_today,
  (select count(*) from letter_letters where type = 'Renalware::Letters::Letter::Draft' and created_at < (current_date - interval '14 days')) as draft_letters_older_than_14_days;

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
renalware-core-2.1.1	db/views/reporting_daily_letters_v03.sql
renalware-core-2.1.0	db/views/reporting_daily_letters_v03.sql