← Back to branch summary

~registry/dhis2-academy/group3_messaging_support

« back to all changes in this revision

Viewing changes to resources/sql/integritychecks.sql

  • Committer: michaelgunnulfsen at gmail
  • Date: 2011-11-18 15:42:06 UTC
  • mfrom: (4968.1.62 Address_Book_group-4)
  • Revision ID: michaelgunnulfsen@gmail.com-20111118154206-akum3pg1i1jbk9iy
merged new searching functionality with addressbook

Show diffs side-by-side

added added

removed removed

Lines of Context:
resources/sql/integritychecks.sql
59
59
join reporttable t using(reporttableid)
60
60
where t.name='Indicators';
61
61
 
 
62
-- Show collection frequency of data elements with average aggregation operator
 
63
 
 
64
select distinct de.name, periodtype.name 
 
65
from dataelement de 
 
66
join datasetmembers using (dataelementid) 
 
67
join dataset using (datasetid) 
 
68
join periodtype using(periodtypeid) 
 
69
where de.aggregationtype = 'average';
 
70
 
62
71
-- Recreate indexes on aggregated tables
63
72
 
64
73
drop index aggregateddatavalue_index;