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 <aaroncwh...@gmail.com> wrote: > 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 <(919)%20522-5585> > > On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken <mar...@joyouscoding.com> > 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 <aaroncwh...@gmail.com> >> 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 < >>> mar...@joyouscoding.com> 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 : mar...@joyouscoding.com >>>> 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@lists.launchpad.net >>>> 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 : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> > > -- *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 : mar...@joyouscoding.com 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
