dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #13019
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