Yes, sorry about that. We have 'de.categorycomboid' and 'cc.categorycomboid'. You can delete one of them.
Sam Kasozi +256 788-993-565 Skype: sam.kasoziug On Fri, Apr 7, 2017 at 2:10 PM, vunda limbe <vunda...@gmail.com> wrote: > Hi Sam, > > Thank you for the script, but It's sending back this message: ERROR: > column "categorycomboid" specified more than once > > > > On Fri, Apr 7, 2017 at 9:42 AM, Sam Kasozi <kaso...@gmail.com> wrote: > >> 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 >>> >>> >> >
_______________________________________________ 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