------------------------------------------------------------ revno: 16876 committer: Lars Helge Overland <[email protected]> branch nick: dhis2 timestamp: Tue 2014-09-30 10:04:49 +0200 message: SQL modified: resources/sql/integritychecks.sql
-- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'resources/sql/integritychecks.sql' --- resources/sql/integritychecks.sql 2013-05-28 08:27:16 +0000 +++ resources/sql/integritychecks.sql 2014-09-30 08:04:49 +0000 @@ -1,4 +1,14 @@ +-- Get periods with equal period type and start date (not valid) + +select p1.periodtypeid, p1.startdate, p1.enddate +from period p1 +inner join period p2 +on p1.periodtypeid = p2.periodtypeid +and p1.startdate = p2.startdate +where p1.periodid != p2.periodid +order by p1.periodtypeid, p1.startdate, p1.enddate; + -- Get name of datasets for a dataelement select ds.name from dataset ds
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
