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 <vunda...@gmail.com> 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.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
