[Dhis2-users] Tables for SQL queries -- indicators

2017-02-04 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 Users, I would like to run SQL to query indicators values through SQL View. On which tables should I query from if for the dataelements, the SQL queries are based on dataValues (dv) table? I am using DHIS2 2.24 Thank you for your support! Kind Regards, Tantely. -- *This message an

Re: [Dhis2-users] Tables on event capture

2016-02-23 Thread Ola Hodne Titlestad
Hi Eric and Prosper, Prosper, agree we should not allow category combinations to be selected for data elements with domain type 'tracker'. As to your example I'd like to add that for events it would probably make more sense to create separate data elements for 'age' (numeric) and 'gender' (text w

Re: [Dhis2-users] Tables on event capture

2016-02-23 Thread Prosper BT
Dear Eric, Tracker both with and without registration data elements dont support category combinations. Its bad that its misleading in the design because when you select the domain type as tracker it still allow yo to select the category combination. In the events you will have to create each cat

[Dhis2-users] Tables on event capture

2016-02-23 Thread eric mourin
Hello, I have been trying to create tables using Category Combinations on data elements and so far they have worked fine for data sets. Nevertheless, when I used the same setup for event capture, the tables were not created and only the data element was shown. Is this functionality implemented?

Re: [Dhis2-users] Tables

2015-08-05 Thread Abyot Gizaw
Hi Simon, It is trackedentitydatavalue table. Thank you, Abyot. On Wed, Aug 5, 2015 at 9:23 AM Simon Muyambo wrote: > Hi > > > > What table is used to store data capture event capture? > > > > *Regards* > > *Simon Muyambo* > > > > > __ Information from ESET NOD32 Antivirus, version of

[Dhis2-users] Tables

2015-08-05 Thread Simon Muyambo
Hi What table is used to store data capture event capture? Regards Simon Muyambo <> ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help