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.147 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.146 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.145 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.144 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.143 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.142 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.141 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.140 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.139 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.138 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.137 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.136 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.135 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.134 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.133 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.132 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.131 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.130 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.129 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.128 db/views/reporting_daily_ukrdc_v01.sql