dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #36451
[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