neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
datasetsummary(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)
Parameters
Name
Type
Mode
startperiod
integer
IN
endperiod
integer
IN
databasename
character varying
TABLE
counts
bigint
TABLE
Definition
SELECT dst.datasettype, count(*) FROM ndb.datasets AS ds JOIN ndb.datasettypes AS dst ON ds.datasettypeid = dst.datasettypeid JOIN ndb.datasetsubmissions AS dss on dss.datasetid = ds.datasetid JOIN ndb.constituentdatabases AS cdb ON cdb.databaseid = dss.databaseid WHERE EXTRACT(month from AGE(NOW(), dss.submissiondate)) BETWEEN 1 and 2 GROUP BY cdb.databasename, dst.datasettype