← Back to team overview

dhis2-users team mailing list archive

Re: How to output all data element list with their categories option DHIS2 V2.23 using SQLview

 

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 <kasozis@xxxxxxxxx> 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 <vundalon@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

Follow ups

References