dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #49197
Re: Program indicator "hasValue"
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.poppe@xxxxxx>:
>
> 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 <markus@xxxxxxxxx <mailto:markus@xxxxxxxxx>>:
>>
>> 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.poppe@xxxxxx <mailto:olav.poppe@xxxxxx>>:
>>>
>>> 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@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>> Unsubscribe : https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
>>> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
>>
>
Follow ups
References