dhis2-users team mailing list archive

[vunda limbe <vundalon@xxxxxxxxx>]

Hi every body,

I need to show option and their uid in the request, but I don't find the
category option table and the way to link with this request.

Please help.


Thanks

On Fri, Apr 7, 2017 at 12:47 PM, vunda limbe <vundalon@xxxxxxxxx> wrote:

> Hi David and Sam,
>
> I tried, it works now after deleting one of categorycomboid.
>
> Thanks
>
> On Fri, Apr 7, 2017 at 11:58 AM, David Palmer <
> David.Palmer@xxxxxxxxxxxxxxx> wrote:
>
>> Hi Vunda,
>>
>>
>>
>> I think you’re making the same mistake I first made and trying to set it
>> up as an SQL view.
>>
>> If you select “SQL query” instead it should save and run fine.
>>
>> Cheers,
>>
>> Dave
>>
>>
>>
>> *Dave Palmer *– MIS Technical Advisor
>>
>> *T* +44 (0) 20 3219 8098
>>
>> *M* +44 (0) 7757 109777
>>
>> *skype* dave-MSI
>>
>> david.palmer@xxxxxxxxxxxxxxxxxx
>>
>> www.mariestopes.org
>>
>>
>>
>> Marie Stopes International
>>
>> 1 Conway Street
>>
>> Fitzroy Square
>>
>> London W1T 6LP
>>
>> United Kingdom
>>
>>
>>
>>
>>
>> *From:* Dhis2-devs [mailto:dhis2-devs-bounces+david.palmer=
>> mariestopes.org.uk@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *vunda limbe
>> *Sent:* 07 April 2017 10:41
>> *To:* Sam Kasozi
>> *Cc:* DHIS 2 Users list; DHIS 2 Developers list
>> *Subject:* Re: [Dhis2-devs] [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
>>
>>
>>
>>
>> This Email from Marie Stopes International and any attachments may
>> contain information which is privileged or confidential. It is meant only
>> for the individual(s) or entity named above. If you are not the intended
>> recipient(s) of this Email or any part of it please notify the sender
>> immediately on receipt and delete it from your system. Any opinion or other
>> information in this email or its attachments that does not relate to the
>> business of Marie Stopes International is personal to the sender and is not
>> given or endorsed by Marie Stopes International.
>>
>
>