Resource: Member, Field : MemberLoginId

Description

MemberLoginId must contain only aphanumeric characters, also cannot be a duplicate Id.

Error Messages

1) ERROR, update action is 'Insert/Add', but the entry does not contain only alphanumeric characters.
2) ERROR, update action is 'Insert/Add', but is not unique.
3) ERROR, update action is 'Update/Change', but the entry does not contain only alphanumeric characters.
4) ERROR, update action is 'Update/Change', but is not unique.

Fields referenced within this rule

MemberLoginId

Syntax with comments and error messages

//[ErrMsg1^ERROR, update action is 'Insert/Add', but the entry does not contain only alphanumeric characters.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk3^FALSE]
//[ErrMsg2^ERROR, update action is 'Insert/Add', but is not unique.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk4^FALSE]
//[ErrMsg3^ERROR, update action is 'Update/Change', but the entry does not contain only alphanumeric characters.|LogicBlk1^TRUE|LogicBlk5^TRUE|LogicBlk6^TRUE|LogicBlk7^FALSE]
//[ErrMsg4^ERROR, update action is 'Update/Change', but is not unique.|LogicBlk1^TRUE|LogicBlk5^TRUE|LogicBlk6^TRUE|LogicBlk8^FALSE]
// If entry is not empty and has not changed...
IIF((/*[LogicBlk1]*/(.ENTRY. != .EMPTY.).AND.(UPPER(CHAR(.ENTRY.)) != UPPER(CHAR(.OLDVALUE.)))),
// Then verify update action is 'Insert/Add' and contains only alphanumeric characters and is not a duplicate or...
((/*[LogicBlk2]*/.UPDATEACTION..IN.('Add')).AND.(/*[LogicBlk3]*/ALPHANUMERIC(.ENTRY.)).AND.(/*[LogicBlk4]*/.NOT.DUPLICATE("Member","MemberLoginId",.ENTRY.))).OR.
// update action is 'Update/Change' and the user permission access is CRMLS administrator and contains only alphanumeric characters and is not a duplicate or...
((/*[LogicBlk5]*/.UPDATEACTION..IN.('Change')).AND.(/*[LogicBlk6]*/.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(/*[LogicBlk7]*/ALPHANUMERIC(.ENTRY.)).AND.(/*[LogicBlk8]*/.NOT.DUPLICATE("Member","MemberLoginId",.ENTRY.))),.TRUE.)

Syntax only

IIF(((.ENTRY. != .EMPTY.).AND.(UPPER(CHAR(.ENTRY.)) != UPPER(CHAR(.OLDVALUE.)))),((.UPDATEACTION..IN.('Add')).AND.(ALPHANUMERIC(.ENTRY.)).AND.(.NOT.DUPLICATE("Member","MemberLoginId",.ENTRY.))).OR.((.UPDATEACTION..IN.('Change')).AND.(.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(ALPHANUMERIC(.ENTRY.)).AND.(.NOT.DUPLICATE("Member","MemberLoginId",.ENTRY.))),.TRUE.)

Rule Unique ID

94585d7d-56c6-40fe-b7a2-dd2f0c4c054d

ACCEPT