[Dhis2-devs] [Bug 1600222] Re: program indicators in event reports show 0 for null

2016-07-08 Thread Olav P
It looks like this is a UI issue: sorting the event report table by the indicator will sort the real zeros and the "null" zeros differently. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1600222 T

[Dhis2-devs] [Bug 1600222] [NEW] program indicators in event reports show 0 for null

2016-07-08 Thread Olav P
Public bug reported: In the "events" view of event reports, program indicators show 0 even when the "filter" criteria is not met. E.g. and "Age in years" based on Date of birth and date of death, with filter "date of death is know", will show age = 0 years for cases where age is not know. ** Aff

[Dhis2-devs] [Bug 1600222] Re: program indicators in event reports show 0 for null

2016-07-08 Thread Olav P
** Attachment added: "Skjermbilde 2016-07-08 kl. 14.50.51.png" https://bugs.launchpad.net/dhis2/+bug/1600222/+attachment/4697413/+files/Skjermbilde%202016-07-08%20kl.%2014.50.51.png -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHI

[Dhis2-devs] [Bug 1600208] Re: program indicator d2:yearsBetween not working

2016-07-08 Thread Olav P
The same seems to be the case for d2:floor() -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1600208 Title: program indicator d2:yearsBetween not working Status in DHIS: New Bug description:

Re: [Dhis2-devs] 2.24 startup warning message - clarification

2016-07-08 Thread Halvdan Hoem Grelland
Hi Calle, These messages are the result of a known bug in Hibernate (the ORM library we're using). There are no consequences beyond these log lines, though, so they should be ignored. On Fri, Jul 8, 2016 at 2:31 PM, Calle Hedberg wrote: > Hi > > I've got an instance that were created in 2.20, t

[Dhis2-devs] [Bug 1600208] [NEW] program indicator d2:yearsBetween not working

2016-07-08 Thread Olav P
Public bug reported: 2.24 Using d2:yearsBetween in an indicator filter does not seem to work - PT hangs when trying to make a table using a program indicator with d2:yearBetween. The exact same indicator with d2:daysBetween works fine. ** Affects: dhis2 Importance: Undecided Status

[Dhis2-devs] 2.24 startup warning message - clarification

2016-07-08 Thread Calle Hedberg
Hi I've got an instance that were created in 2.20, then upgraded to 2.21, 2.22, 2.23, and finally 2.24. The tomcat log shows a bunch of these warning messages during startup: * WARN 2016-07-08 14:28:11,485 HHH9003: Use of DOM4J entity-mode is considered deprecated (ModelBinder.java [localho

[Dhis2-devs] Program indicators in Event reports

2016-07-08 Thread Olav Poppe
Hi devs, can someone explain how to use program indicators in event reports? I’ve set up a few indicators that all work fine in the Pivot table. However, in the aggregate event report they seem to do nothing at all to the data (and can’t actually be displayed in the table since they don’t show

Re: [Dhis2-devs] Program indicators - nested d2:condition()?

2016-07-08 Thread Alex Tumwesigye
Dear Olav, Good. Let me know if it works. Alex On Fri, Jul 8, 2016 at 2:47 PM, Olav Poppe wrote: > BTW, I see now that my initial formula was completely messed up, but the > bug is still there… > > Olav > > > > > 8. jul. 2016 kl. 13.43 skrev Olav Poppe : > > Thanks Alex, after a bit more diggi

[Dhis2-devs] [Bug 1600202] [NEW] program indicator d2condition bug

2016-07-08 Thread Olav P
Public bug reported: There is a bug in d2:condition which messes up the quotes in the SQL that is generated based on the expression: E.g. this simple d2:condition(): d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'MONTHS', true, false) Is translated into this SQL: select count(distinct psi) as value

Re: [Dhis2-devs] Program indicators - nested d2:condition()?

2016-07-08 Thread Olav Poppe
BTW, I see now that my initial formula was completely messed up, but the bug is still there… Olav > 8. jul. 2016 kl. 13.43 skrev Olav Poppe : > > Thanks Alex, after a bit more digging I think I’ve identified a bug in > d2:condition which might be causing this by messing up the quotes in the

Re: [Dhis2-devs] Program indicators - nested d2:condition()?

2016-07-08 Thread Olav Poppe
Thanks Alex, after a bit more digging I think I’ve identified a bug in d2:condition which might be causing this by messing up the quotes in the SQL that is generated (I might still need the brackets though): This simple d2:condition(): d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'MONTHS', true, f

Re: [Dhis2-devs] Program indicators - nested d2:condition()?

2016-07-08 Thread Alex Tumwesigye
Olav, I have not tried it, how about using brackets? e.g d2:condition(x1,(d2:condition(x2,(d2:condition(x3,x3true,x3false),x2false),x1false) I am not sure if the brackets are supported but it will keep it in the same format. Alex On Fri, Jul 8, 2016 at 1:55 PM, Olav Poppe wrote: > Hi devs, >

[Dhis2-devs] Program indicators - nested d2:condition()?

2016-07-08 Thread Olav Poppe
Hi devs, I’m trying to set up a program indicator that counts events within age groups. Age is collected with two different methods: - Date of birth and date of death - Estimated age (when DoB is not available), using one «periodtype» field and one «period count» field, e.g. 4 and Months in two

Re: [Dhis2-devs] Documentation for d2 library

2016-07-08 Thread Mark Polak
Hey Archana, Let me know if you have any other questions :) On Thu, Jul 7, 2016 at 9:24 PM, Archana Chillala wrote: > Hi Mark, > > Thanks a lot for the detailed response. That was really helpful. > > > *Cheers,* > > Archana Chillala > Application Developer > Email archa...@thoughtworks.com > Te

[Dhis2-devs] Program indicators - counting events without data element value

2016-07-08 Thread Olav Poppe
Hi devs, I was trying to make a program indicator counting the number of events where a certain field has not been filled. Unless I’ve missing something obvious, it is not really documented how to do this. Neither !#{id}, #{id} == ‘’ nor #{id} == null works, they all become translated into SQL