Sha256: ebd40c74d234a4bb018aab19056af5660c2f3f1bf831246325f82f5788e41544

Contents?: true

Size: 118 Bytes

Versions: 110

Compression:

Stored size: 118 Bytes

Contents

select
  (select count(*) from patients where sent_to_ukrdc_at::date = current_date) as patients_sent_to_ukrdc_today;

Version data entries

110 entries across 110 versions & 1 rubygems

Version Path
renalware-core-2.0.127 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.126 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.125 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.124 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.123 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.121 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.120 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.119 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.118 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.117 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.116 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.115 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.113 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.112 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.111 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.110 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.109 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.108 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.106 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.105 db/views/reporting_daily_ukrdc_v01.sql