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