← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] How to output all data element list with their categories option DHIS2 V2.23 using SQLview

 

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.
>

Follow ups

References