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

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

Re: [Dhis2-users] Event Reports

Thanks Prosper.But can't that be looked at in the next versions? I have just upgraded to 2.25 like last week.So I will upgrade to 2.26 once its stable.I always want to be one step behind. My regards Stanley On Feb 4, 2017 9:21 PM, "Prosper BT" wrote: > Dear Stanley, > > This is not yet suppor

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

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] [Dhis2-devs] Feature roadmap for the next releases

Thanks Calle Sent from my iPhone > On 4 Feb 2017, at 17:51, Calle Hedberg wrote: > > Hi > > The normal way: > > 1. go to https://jira.dhis2.org/login.jsp > > 2. If you have registered already, log in with your username and passwordl > > 3. if not registered yet, see the "Not a member? Sign

Re: [Dhis2-users] Event Reports

Dear Stanley, This is not yet supported in event reports and events visualizer. You can now only select form one stage, but if you wish to include the data elements from different stages in creating a program indicator its possible with 2.26 you select enrollment. Regards Prosper Behumbiize, MP

Re: [Dhis2-users] [Dhis2-devs] Feature roadmap for the next releases

Hi The normal way: 1. go to https://jira.dhis2.org/login.jsp 2. If you have registered already, log in with your username and passwordl 3. if not registered yet, see the "Not a member? Sign up for an account." Click on Sign Up, then follow ins

[Dhis2-users] Can a data element have multiple values for the same period & organisation unit if in multiple data sets?

Hi everyone, I'm having a problem with data elements in DHIS2 in version 2.20. I have a data element in multiple data sets, and I'm able to enter different values for the same organisation unit, for the same period in the different data entries containing the same data element. My assumption was

Re: [Dhis2-users] [Dhis2-devs] Feature roadmap for the next releases

Thanks Calle Please how do I sign up to JIRA Regards Kwame Sent from my iPhone > On 4 Feb 2017, at 11:08, Calle Hedberg wrote: > > Vanya, > > It's all on JIRA - much better if you review that directly instead of > requesting separate roadmaps (every additional task like that takes resources

Re: [Dhis2-users] [Dhis2-devs] Feature roadmap for the next releases

Vanya, It's all on JIRA - much better if you review that directly instead of requesting separate roadmaps (every additional task like that takes resources away from progressing on the real stuff, yes?). Register at https://jira.dhis2.org and you can not only see what's in the pipeline, you can ad