Validation Rule - Checking size of attribute

Question

I would like to check if an attribute entered by a user matches exactly a specific number of characters within a validation Rule.

How can I check this? I tried following validation rule to no luck:
rule{
given {
reference = attributes.‘ISO Alpha 2 Code’.size()
}
when {
isNotEqual(reference,2)
}
then{
condition{isNotEmpty(attributes.‘ISO Alpha 2 Code’, message: “ISO Alpha 2 Code must have exactly 2 characters”)}
}
}

arthurburkhardt · Answer

when {} is a filter condition (e.g. the validation rule only applies if the asset matches this condition) The validation logic is groovy syntax, it just needs to return true or false. The validation functions are only useful for the “message” functionality, so you can just write normal groovy whenever you don’t need messages. The attributes is a map of array. When you do attributes.‘ISO Alpha 2 Code’.size() , it will tell you how many attributes of this type are related to the asset. In this case, I expect that the answer will mostly be 0 or 1 (even if the attribute has 2 characters) For your example, here’s a working code: rule { given { code = attributes['ISO Alpha 2 Code'].find() } then{ code && isLengthEq(code, 2, message: "ISO Alpha 2 code should have exactly 2 characters") } } .find() will get the first attribute iso alpha 2, and store it as the variable code code && ensures that the attribute is not null and not 0 length isLengthEq then checks the length of the attribute, and will throw the error message if not 2.

jurgentock · Answer

Glenn, Many thanks for your suggestion! I will give that a try Jurgen

glennde_groot · Answer

Hi Jurgen, You can make use of: isLengthEq (value, length). See for reference: String functions (collibra.com) Regards, Glenn

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