← 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

 

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 <vundalon@xxxxxxxxx> 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 <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
>>>
>>>
>>
>

References