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.1.1 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.1.0 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.167 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.166 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.165 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.164 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.163 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.162 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.161 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.160 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.159 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.158 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.157 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.156 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.155 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.153 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.152 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.151 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.149 db/views/reporting_daily_ukrdc_v01.sql
renalware-core-2.0.148 db/views/reporting_daily_ukrdc_v01.sql