← Back to team overview

dhis2-devs team mailing list archive

[Branch ~dhis2-devs-core/dhis2/trunk] Rev 18648: SQL

 

------------------------------------------------------------
revno: 18648
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Fri 2015-03-20 13:10:23 +0100
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	2015-02-04 21:42:37 +0000
+++ resources/sql/div.sql	2015-03-20 12:10:23 +0000
@@ -82,6 +82,14 @@
 inner join categorycombo cc on ccoc.categorycomboid=cc.categorycomboid
 where coc.categoryoptioncomboid=2118430;
 
+-- Display overview of category option combos
+
+select coc.uid as optioncombo_uid, cocn.categoryoptioncomboname as optioncombo_name, cc.uid as categorycombo_uid, cc.name as categorycombo_name 
+from categoryoptioncombo coc 
+inner join _categoryoptioncomboname cocn on coc.categoryoptioncomboid=cocn.categoryoptioncomboid 
+inner join categorycombos_optioncombos ccoc on coc.categoryoptioncomboid=ccoc.categoryoptioncomboid 
+inner join categorycombo cc on ccoc.categorycomboid=cc.categorycomboid;
+
 -- Get category option combos linked to category option
 
 select coc.categoryoptioncomboid as coc_id, coc.uid as coc_uid, co.categoryoptionid as co_id, co.name as co_name