dhis2-users team mailing list archive

[Aaron C White <aaroncwhite@xxxxxxxxx>]

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 of the data element in question.  I don't think you can use it to
hit the analytics endpoint directly.  You can find some examples and more
detail here
<https://docs.dhis2.org/2.28/en/user/html/configure_program_indicator.html#program_indicator_functions_variables_operators>
.

Aaron


--
Aaron C. White
919.522.5585

On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken <martin@xxxxxxxxxxxxxxxx>
wrote:

> 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
>