Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Hello ! Good to know, thanks. To be fair - the doc does not refer to any support of a null operator, I just tried my luck there. I'll try Aaron logic - if I can create an indicator whose value would be 0 when the 'main' indicator has no value, I got a proxy for my query which is all I need. I'll

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Dear Martin, Refer to this jira issues DHIS2-1219 requesting additional support for Null and missing in Events report filters Its to be done in 2.30 Regards Prosper Behumbiize, MPH DHIS2 Implementation Adviser| HISP Uganda pros...@hispuganda.org

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Hi, Seems we have a bug there... please file a JIRA issue and we would address it as soon as we can. Otherwise, since 2.25 on we have introduced support to filter events based on data element values. You can play around with columns of the event grid in event capture app to see the request url

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Ok, got it, I was missing some context. Looks an interesting way to actually tackle some of the "queries" I have to do for a project. Thanks a lot! Martin On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White wrote: > I just had to tackle something similar recently, so it's

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

I just had to tackle something similar recently, so it's fresh on my mind. The functions are built in to DHIS2 (but I believe are part of the JEXL library according to the docs).You would need to create the program indicator first, run analytics, and then request the program indicator instead

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Would not have though of that approach - your examples uses the d2 JS library? Are those "operators" usable in a analytics/events/query filter string? (tried the "aggregate" null operator, but it did not work) Thanks ! Martin On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

Martin, What if you made a program indicator with inverse logic? Something like "!d2:hasValue(#{your_de_uid})", since if the value is numeric "d2:oizp(#{your_de_uid})". d2:oizp returns 1 if the value is zero or positive and otherwise returns 0. I bet one of those or a combination would solve

[Dhis2-users] Event Report (Events) - select data items which have no value

Hi everyone, We are interested to get an event report with all events where a specific data item has no value (ie, not 0, no value at all). We're on 2.26, an all the conditins available are <, <=, =, > etc. Putting "=" then an empty field does not filter anything, and in this case "0" is taken as