dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #49101
Re: [Dhis2-users] 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