CHARS_FROM_RIGHT

vinsnash

Will this work?

FOR EACH NSCPers CREATE Pending WITH
Pending.LastFour=CHARS_FROM_RIGHT(NSCPers.SocialSecurityNumber,4),

The reason I'm asking is because misspelling "CHARS_FROM_RIGHT" is not caught as an error when editing rules for a process.

Vins Nash

aware_support

There is a bug in using arithmetic expressions (such as CHARS_FROM_RIGHT function) inside CREATE FOR EACH. As a workaround define calculated attributes in the original object and then copy this attribute into the object being created. For example,

NSCPers.LastFour = CHARS_FROM_RIGHT(NSCPers.SocialSecurityNumber,4)

CREATE Pending FOR EACH NSCPers WITH
Pending.LastFour=NSCPers.LastFour, ...