dhis2-devs team mailing list archive

[Olav Poppe <olav.poppe@xxxxxx>]

Great, thanks.

Olav


> 24. apr. 2017 kl. 21.27 skrev Markus Bekken <markus@xxxxxxxxx>:
> 
> 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 <mailto: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>
>>> 
>> 
>