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