dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 11226
committer: Lars Helge Øverland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Tue 2013-06-18 19:50:40 +0200
message:
  SQL
modified:
  resources/sql/div.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/div.sql'
--- resources/sql/div.sql	2013-04-25 12:34:36 +0000
+++ resources/sql/div.sql	2013-06-18 17:50:40 +0000
@@ -140,6 +140,14 @@
   where orgunitgroupid=o.orgunitgroupid)
 order by type,name;
 
+-- Display overview of data elements and related category option combos
+
+select de.uid as deuid, de.name as dename, coc.uid as cocuid, con.categoryoptioncomboname
+from dataelement de
+join categorycombos_optioncombos cc using(categorycomboid)
+join categoryoptioncombo coc using(categoryoptioncomboid)
+join _categoryoptioncomboname con using(categoryoptioncomboid);
+
 -- Populate dashboards for all users (7666 is userinfoid for target dashboard, replace with preferred id)
 
 insert into usersetting (userinfoid, name, value)