Validating for empty string thru validation rule

Support - Assistance technique
1

Hi all,

Please note I would like to add a validation rule to check for empty values. For example, I want to validate like

NAME = EMPTY

But I am not able to add an empty string like “” on the “right side expression”.

Please assist.

2

Hi,

You use the function d2:hasValue(‘name’) to check for non-empty values (or the same with ! in front to check for empty values).

Regards
Calle

1 Like
3

Hi @Calle_Hedberg,

Thanks for your reply.

Please note I am trying this validation under “validation rule”. This section of the app does not allow d2 functions. d2 functions are working under program rule but not allowed (may be I am wrong) here.

ValErro
ValErro883×415 54.2 KB

As you see I am getting a “Expression is not well-formed” error.

1 Like
4

@MSP,

Apologies, I misunderstood your inquiry there. And you are probably right, I’ve never seen Regex type expressions under validation rules.

Did you try “… IS NULL”?

Regards
Calle

1 Like
5

Thanks for the hint. I will try and update.

1 Like
6

Hi @MSP,

Was @Calle_Hedberg’s recommendation helpful?

Best,
James.

7

Sorry I missed to update here. Nope, it did not work.

8

Did you manage to work around it?

9

To my understanding, validation rule will not help to achieve this. So we developed a procedure to achieve what we wanted.

1 Like