Hi Everybody, I got this request that helps me output date element and their category sent through the mailling list. Now I need to output the same thing with in addition the category option name and its uid. Please, could someone can help?
Sql query : SELECT de.dataelementid, de.uid as dataelmt_uid, de.name as dataelementname, de.shortname as dataelementshortname, coc.categoryoptioncomboid, cc.name as ccname, coc.name as cocname, coc.uid as cocuid, cc.categorycomboid, cc.uid as ccuid, dataelementcategoryoption.name as opname, dataelementcategoryoption.uid as opuid FROM dataelement de LEFT JOIN categorycombos_optioncombos coccc on de.categorycomboid = coccc.categorycomboid LEFT JOIN categorycombo cc ON coccc.categorycomboid = cc.categorycomboid LEFT JOIN categoryoptioncombo coc ON coccc.categoryoptioncomboid = coc.categoryoptioncomboid ORDER BY de.dataelementid Thanks.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
