Great, thanks. Olav
> 24. apr. 2017 kl. 21.27 skrev Markus Bekken <mar...@dhis2.org>: > > Hey Olav, > if you're on 2.26 or later, d2:hasValue() should work: > https://jira.dhis2.org/browse/DHIS2-1245 > <https://jira.dhis2.org/browse/DHIS2-1245> > > Markus > >> 24. apr. 2017 kl. 13.09 skrev Olav Poppe <olav.po...@me.com >> <mailto:olav.po...@me.com>>: >> >> Hi, late follow-up on this - is there a «is empty» syntax for dates as well? >> I get >> >> ERROR: invalid input syntax for type timestamp: ‘' >> and >> ERROR: COALESCE types timestamp without time zone and integer cannot be >> matched >> >> if I use == ‘’ or == 0 respectively for dates. >> >> Olav >> >> >> >> >> >> >>> 1. mar. 2017 kl. 15.24 skrev Markus Bekken <mar...@dhis2.org >>> <mailto:mar...@dhis2.org>>: >>> >>> Hi Olav, >>> the following syntax is now supported: >>>> - #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ >>> >>> Jira issue: https://jira.dhis2.org/browse/DHIS2-1185 >>> <https://jira.dhis2.org/browse/DHIS2-1185> >>> >>> Best regards, >>> Markus >>> >>>> 1. feb. 2017 kl. 13.40 skrev Olav Poppe <olav.po...@me.com >>>> <mailto:olav.po...@me.com>>: >>>> >>>> Hi devs, I’m trying (in 2.25) to make a program indicator counting events >>>> where a specific data element has not been filled. >>>> >>>> Tested so far: >>>> - d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in >>>> program indicators, only program rules >>>> - #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data >>>> - #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the >>>> events WITH data, but I’m unable to «invert» this: >>>> -- !(#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) => no data, >>>> catalina.out shows: ERROR: operator does not exist: ! boolean >>>> -- (#{wmSb9TmevMn.jeK5z6acB3N} != '') != true => no data >>>> - #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but >>>> is not a supported format from what I understand. >>>> >>>> In general, what is displayed in «Filter description» and what actually >>>> works is not consistent - some things are invalid, but work, others are >>>> valid but don’t work… >>>> >>>> Any advice? >>>> >>>> Regards >>>> Olav >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> <https://launchpad.net/~dhis2-devs> >>>> Post to : dhis2-devs@lists.launchpad.net >>>> <mailto:dhis2-devs@lists.launchpad.net> >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> <https://launchpad.net/~dhis2-devs> >>>> More help : https://help.launchpad.net/ListHelp >>>> <https://help.launchpad.net/ListHelp> >>> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp