Hi Vunda,
Try out the attached script.
regards,
Sam Kasozi
+256 788-993-565
Skype: sam.kasoziug
On Fri, Apr 7, 2017 at 1:00 PM, vunda limbe <vunda...@gmail.com> wrote:
> Hi everybody,
>
> I'm looking for SQL code to list data element name, id, uid,
> categoryoptioncombouid, categoryoptioncomboname.
> I don't know exactly wich table I have to insert in my query for listing
> the content.
>
> Your supports are welcome
>
> Thanks.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>
>
SELECT de.name as dataelementname, de.shortname as dataelementshortname, de.uid
as de_uid, de.dataelementid, de.categorycomboid,
coc.name as cocname, coc.uid as cocuid, coc.categoryoptioncomboid,
cc.categorycomboid, cc.name as ccname, cc.uid as ccuid
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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
