------------------------------------------------------------ revno: 18647 committer: Lars Helge Overland <[email protected]> branch nick: dhis2 timestamp: Fri 2015-03-20 09:07:48 +0100 message: Integrity checks 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 2015-03-04 21:09:59 +0000 +++ resources/sql/integritychecks.sql 2015-03-20 08:07:48 +0000 @@ -186,6 +186,14 @@ select categoryoptioncomboid, count(categoryoptioncomboid) as count from categorycombos_optioncombos group by categoryoptioncomboid having count(categoryoptioncomboid) > 1; +-- Get additional default option combos 1 + +select * from categoryoptioncombo coc inner join categorycombos_optioncombos ccoc on coc.categoryoptioncomboid=ccoc.categoryoptioncomboid inner join categorycombo cc on ccoc.categorycomboid=cc.categorycomboid where cc.name = 'default' offset 1; + +-- Get additional default option combos 2 + +select * from categoryoptioncombo coc inner join categoryoptioncombos_categoryoptions cocco on coc.categoryoptioncomboid=cocco.categoryoptioncomboid inner join dataelementcategoryoption co on cocco.categoryoptionid=co.categoryoptionid where co.name = 'default' offset 1; + -- Get category options with count of memberships in categories select cc.categoryoptionid, co.name, (
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
