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.pal...@mariestopes.org> 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.pal...@mariestopes.org.uk > > 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...@lists.launchpad.net] *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 <kaso...@gmail.com> 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 <vunda...@gmail.com> 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-us...@lists.launchpad.net > 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. >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
