Thanks Lars. Unfortunately, this isn’t working for me. It’s still treating the
blank data value as a zero and passing validation with blanks.
In case there have been changes in later builds - this is version 2.25 build
da6a2df.
Ideally, we would also like to be able to compare to NULL on one side of the
equation, so that we can do more complex logic (e.g. : #{Data Value A} NOT
NULL || #{Data Value B} > 0). But that might be beyond the scope of what the
validation rules can do right now.
Appreciate your feedback!
Thanks,
Becky
From: Lars Helge Øverland [mailto:l...@dhis2.org]
Sent: Tuesday, February 14, 2017 5:02 PM
To: Smith, Rebecca A.
Cc: dhis2-users
Subject: Re: [Dhis2-users] Validation Rules with zeros and nulls
Hi Becky,
did you try creating a rule like this?
- left side missing value strategy is set to "never skip".
- left side expression is the relevant data element.
- operator is "greater than or equal to".
- right side missing value strategy is set to "never skip".
- right side expression is 0.
Lars
On Tue, Feb 14, 2017 at 10:21 PM, Smith, Rebecca A.
<rs3...@cumc.columbia.edu<mailto:rs3...@cumc.columbia.edu>> wrote:
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: rs3...@cumc.columbia.edu<mailto:rs3...@cumc.columbia.edu>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to :
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
