Program indicators - counting events without data element value

Hi devs,
I was trying to make a program indicator counting the number of events where a certain field has not been filled. Unless I’ve missing something obvious, it is not really documented how to do this. Neither !#{id}, #{id} == ‘’ nor #{id} == null works, they all become translated into SQL that is invalid and/or does not give the required result in the case of #{id} = ‘’.

In the end, I was able to make it work by using «is null» and «is not null», but you will then get a «Filter is not evaluating to true or false» message in the GUI, which is not ideal if this is the recommended way to do this?



1 Like