dhis2-users team mailing list archive

["Smith, Rebecca A." <rs3524@xxxxxxxxxxxxxxxxx>]

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:lars@xxxxxxxxx]
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. <rs3524@xxxxxxxxxxxxxxxxx<mailto:rs3524@xxxxxxxxxxxxxxxxx>> 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: rs3524@xxxxxxxxxxxxxxxxx<mailto:rs3524@xxxxxxxxxxxxxxxxx>


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
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
lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>
http://www.dhis2.org<https://www.dhis2.org/>