Comparing field contents

Question

I want to compare the first few characters of the Description field with the first few characters of a different field (system name). For instance, I need to ensure the system name is included at the beginning of the field.

I tried using the “starttsWith” command in my script, but receive the error message. "A syntax problem was encountered in rule “Compare fields”. It defines a ‘startsWith’ method that can not be found."

Collibra is geting hung up on:

startsWith(description, “X”, message: “OK”)

Thanks

S Benson · Answer

I actually wrote the code to do what I needed… Scott

arthurburkhardt · Answer

yes, the syntax is

description.startsWith(“X”, message: “OK”)`

Example:

rule {
  isFalse( isAny(relations['c0e00000-0000-0000-0000-000000007347'], { displayName.startsWith(it.name) }),
        message: "The processing activity name cannot start with the associated Technology asset name")
}

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