Resource: Office, Field : OfficeMlsId

Description

OfficeMlsId can only be alphanumeric characters and there cannot be a duplicate Id.

Error Messages

1) ERROR, entry cannot be a duplicate of an existing office.
2) ERROR, entry must consist of only alphanumeric characters.

Fields referenced within this rule

OfficeMlsId

Syntax with comments and error messages

// TODO - un-noop and test Duplicate case when new service is made available
//[ErrMsg1^ERROR, entry cannot be a duplicate of an existing office.|LogicBlk1^TRUE|LogicBlk2^FALSE]
//[ErrMsg2^ERROR, entry must consist of only alphanumeric characters.|LogicBlk1^TRUE|LogicBlk3^FALSE]
// If the the entry is not empty and has changed...
IIF((/*[LogicBlk1]*/(.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),
// Then verify that the entry is not a duplicate and is only alphanumeric characters...
(/*[LogicBlk2]*/.NOT.DUPLICATE("Office","OfficeMlsId",.ENTRY.).AND.(/*[LogicBlk3]*/ALPHANUMERIC(.ENTRY.))),
// Else entry is empty or unchanged so accept.
.TRUE.)

Syntax only

IIF(((.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),(.NOT.DUPLICATE("Office","OfficeMlsId",.ENTRY.).AND.(ALPHANUMERIC(.ENTRY.))),.TRUE.)

Rule Unique ID

08493581-cb17-4d3d-a746-bfe28b7a276c

ACCEPT