← Back to team overview

dhis2-users team mailing list archive

Re: 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 <aaroncwhite@xxxxxxxxx> wrote:

> 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 that problem.
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585 <(919)%20522-5585>
>
> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <martin@xxxxxxxxxxxxxxxx>
> wrote:
>
>> 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 a separated value than "no value".
>>
>> Is there any way to do this?
>>
>> Thanks,
>>
>> Martin
>>
>> --
>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>
>> Mobile : +32 486 899 652
>>
>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
>> Call me on Skype : vanakenm
>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>> Company website : www.joyouscoding.com
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
*Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
Call me on Skype : vanakenm
Hang out with me : martin@xxxxxxxxxxxxxxxx
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com

Follow ups

References