dhis2-users team mailing list archive

Thread
Date

Validation Rules with zeros and nulls

To: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: "Smith, Rebecca A." <rs3524@xxxxxxxxxxxxxxxxx>
Date: Tue, 14 Feb 2017 21:21:29 +0000
Accept-language: en-US
Thread-index: AdKHB9ET8oa8D3yAS7i/sPPoCsO8hw==
Thread-topic: Validation Rules with zeros and nulls

Hi DHIS community,

Could someone advise me on how to distinguish between a zero and a null in a validation rule?

Basically, I want the validation to pass if a data value is not blank. It should pass even if the value is zero, as long as it's is filled in. "Zero is significant" is on.

I tried d2:hasValue from the program rules, but got the "expression is not well-formed" message. Is there a different way to check this in validation rules?

Thanks!
Becky



Becky Smith
Development-Operations Specialist
ICAP at Columbia University
Tel: 212.304.7109
Email: rs3524@xxxxxxxxxxxxxxxxx<mailto:rs3524@xxxxxxxxxxxxxxxxx>

Follow ups

Re: Validation Rules with zeros and nulls
From: Lars Helge Øverland, 2017-02-14