[Dhis2-devs] SQLview - protected tables

Hi, Getting the following error while trying to get user list for a given organization unit in sql view: "SQL query contains references to protected tables" The query is here: --- SELECT userinfo.surname, userinfo.firstname, organisationunit.name FROM public.usermembership, public.use

Re: [Dhis2-devs] SQLview - protected tables

Hi, Yes, the main user tables are protected. If you have access to the "backend" database, you can bypass it using a construct (query/function) that "re-packages" the user table information so that it can be accessed via sql view. Works, but obviously it creates a security risk (the main user ta

[Dhis2-devs] version 2.29 overview

Hi, for those looking for brief overview of the features which went into 2.29 (and found the release notes tl;dr ) you can find a visual summary here: https://www.dhis2.org/229 regards, Lars -- Lars Helge Øverland Technical lead,

Re: [Dhis2-devs] Dashboard Development

Hi Edouard, Thanks, helpful tips. Will consider them and revert soonest. On Mon, Mar 12, 2018 at 9:01 AM, Calle Hedberg wrote: > Hi, > > PEPFAR is using DHIS2 as their database platform. BUT they are also using > a lot of other tools on top of that for analysis, reporting, and display. > > DHI

Re: [Dhis2-devs] Dashboard Development

Very helpful link, Jean. Will definitely have a deep look into it. Thanks. On Mon, Mar 12, 2018 at 11:59 AM, J. Paul Mutali wrote: > Hi Leke, > > you can get more information on how to create an app with DHIS by > enrolling to this DHIS2 Web Apps Development course: https://training. > dhis2.org

[Dhis2-devs] DHIS 2 on stackexchange

Hi, as some of you have noticed we have a *dhis2* tag on the *ProWebmasters* community on StackExchange. This platform is for Q&A, meaning concrete questions with concrete answers (as opposed to e.g. the long conversations you can find on the mailing lists). There are currently several open and u

Re: [Dhis2-devs] DHIS 2 on stackexchange

Hi Lars, I have seen that reddit is also sometimes used for DHIS2 questions. Out of curiosity, and I am sure it is a discussion you already had many times: Why DHIS2 doesnt have their own forum? That is usually the case for open-source projects of that size, and it would create a knowledge base.

Re: [Dhis2-devs] [Dhis2-users] version 2.29 overview

Thanks Lars, We're taking it for a spin, we'll getting back to you with feedback. Excellent job. On Tue, Mar 13, 2018 at 3:24 PM, Lars Helge Øverland wrote: > Hi, > > for those looking for brief overview of the features which went into 2.29 > (and found the release notes tl;dr >