← Back to team overview

dhis2-users team mailing list archive

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

Follow ups

References