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

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

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

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 wrote: > Hi everybody, > > I'm looking for SQL code to list data element name, id, uid, > categoryoptioncombouid, categoryoptioncomboname. > I don't know

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

Yes, sorry about that. We have 'de.categorycomboid' and 'cc.categorycomboid'. You can delete one of them. Sam Kasozi +256 788-993-565 Skype: sam.kasoziug On Fri, Apr 7, 2017 at 2:10 PM, vunda limbe wrote: > Hi Sam, > > Thank you for the script, but It's sending back this message: ERROR: > colu

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 wrote: > Hi Vunda, > > Try out the attached script. > > regards, > > Sam Kasozi > +256 788-993-565 > Skype: sam.kasoziug >

Re: [Dhis2-devs] Questions in DataStore API

Hello DHIS-Devs, We use Datastore api to store data related to our app under our app namespace. As mentioned earlier we see that as most other APIs the dataStore GET api/dataStore/ don’t support lastUpdated. We are planning to introduce lastUpdated filter on this API. Will you be open for tha

Re: [Dhis2-devs] Questions in DataStore API

Hi Jhansi, yes please go ahead, will be a useful feature. regards, Lars On Fri, Apr 7, 2017 at 12:12 PM, jhansirk wrote: > Hello DHIS-Devs, > > We use Datastore api to store data related to our app under our app > namespace. As mentioned earlier we see that as most other APIs the > dataStore

Re: [Dhis2-devs] Questions in DataStore API

Thanks Lars, will send you a pull request soon. > On 07-Apr-2017, at 3:46 PM, Lars Helge Øverland wrote: > > Hi Jhansi, > > yes please go ahead, will be a useful feature. > > regards, > > Lars > > > On Fri, Apr 7, 2017 at 12:12 PM, jhansirk > wrote: > Hell

[Dhis2-devs] Transfer data from one category option to another

Hello Devs,I would like to know if it is possible to transfer data stored against a category option to a another one? There was a mistake in the initial setup of the category options for the data element and users have entered data against that option. The correct category option already exists

Re: [Dhis2-devs] [Dhis2-users] 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 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

Re: [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

Hi Tantely, to achieve this I think you should use the "org unit group" selection mode. Under the organisation unit dimension section, click the gear icon and select "Select groups", then select the org unit group which contains the org units you would like to display. In the org unit tree you ca

Re: [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

Hi Lars, Thank you for this very clear instruction. It is straightforward and very useful! Regards, Tantely. Le 7 avr. 2017 6:25 PM, "Lars Helge Øverland" a écrit : > > Hi Tantely, > > to achieve this I think you should use the "org unit group" selection > mode. Under the organisation unit di

[Dhis2-devs] Analyze across events

Hi, I need to analyze data across variables in two events in a program with multiple stages. For example, I need to find the number of patients marked as cured in *treatment outcome* stage, for a cohort registered during a specified time. Can I combine enrollment date or date from another event