Validation scripts

Question

I know how to write a validation script that check for “and”, that is conditions 1 and 2 must be met in order to pass the validation, but is it possible to write a routine that checks for either condition 1 or condition 2, or both?

For example, in order to pass the validation, a system must have

A relationship to a database
A relationship to file
A relationship to both

However, if it does have a least one of these. it fails the validation!

Thanks

S Benson · Answer

Arthur, As usual, thanks for the outstanding reply! Scott

arthurburkhardt · Answer

How do you check for AND at the moment? For OR , there are at least two ways to do it: AnyOf (collibra syntax) || (groovy syntax) https://productresources.collibra.com/docs/cloud-admin/latest/#DGCSettings/OperatingModel/ValidationRules/ValidationLogic/ref_multi-line-boolean-expressions.htm Method 1: AnyOf rule { allOf { anyOf { allOf { condition { isNotEmpty (name) } condition { isEqual (name, 'doesnotequal2', message:\ 'shouldfail') } } condition { isEqual (name, 'doesnotequal') } } condition { isNotEmpty (id) } } } Method 2: || rule { ((isNotEmpty (name) && isEqual (name, 'doesnotequal2', message: 'shouldfail')\ || isEqual (name, 'doesnotequal')) && isNotEmpty (id) }

S Benson · Answer

Arthur, Thanks - The underlying question is “how do I validate for OR”. I know how to do AND. Scott

arthurburkhardt · Answer

You might have an overly complex validation rule.
If you want to validate for

(A == TRUE) OR (B ==TRUE) OR (A == TRUE AND B == TRUE)

then just validate for

(A == TRUE OR B == TRUE)

. It will match all your requirements.

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard