Re: [Dhis2-devs] Tables for SQL queries -- indicators

2017-02-05 Thread Raminosoa Rabemanantsoa, Tantely
Dear Jason, Thank you for this information. I will adapt the calculations from dataElements then. It is a bit hard to output from the analytics as we need the values of specific indicators of all the lowest level of orgUnits across all periods, so we need to split the queries into orgUnits / perio

Re: [Dhis2-devs] Tables for SQL queries -- indicators

2017-02-04 Thread Jason Pickering
Hi Tantley, This is not really so straightforward with SQL as far as I know, as indicators are calculated "on-the-fly" from the "analytics_***" tables. They are never persisted in the database, so you would need a means to parse the syntax of the indicator, and make the calculation from that. I see

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