How to output all data element list with their categories option DHIS2 V2.23 using SQLview

Support - Assistance technique
1

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.

2

Hi Vunda,

Try out the attached script.

regards,

Data Element, CatCombo and Options.sql (558 Bytes)

···

On Fri, Apr 7, 2017 at 1:00 PM, vunda limbe vundalon@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

3

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@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 vundalon@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4

Yes, sorry about that.

We have ‘de.categorycomboid’ and ‘cc.categorycomboid’. You can delete one of them.

···

On Fri, Apr 7, 2017 at 2:10 PM, vunda limbe vundalon@gmail.com wrote:

Hi Sam,

Thank you for the script, but It’s sending back this message: ERROR: column “categorycomboid” specified more than once

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Fri, Apr 7, 2017 at 9:42 AM, Sam Kasozi kasozis@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 vundalon@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

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@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.palmer@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.uk@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 kasozis@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 vundalon@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-users@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.

6

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@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.Palmer@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.palmer@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.uk@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 kasozis@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 vundalon@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-users@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.