SET_REQUIRED

Resource: Property, Field : BathroomsThreeQuarter

Description

BathroomsOneQuarter is required if other bathroom fields are empty. BathroomsOneQuarteris not required for Boat Slip or Deeded Parking.

Error Messages

1) ERROR, the property type and sub-type is valid and all other types of bathrooms are empty, indicate that the field is required.
2) ERROR, the property type and sub-type is valid and  update type is 'change' and all old bathroom values are empty, indicate that the field is required.

Fields referenced within this rule

BathroomsFull 

BathroomsHalf 

BathroomsOneQuarter 

BathroomsThreeQuarter 

PropertySubType 

PropertyType 

Syntax with comments and error messages

//[ErrMsg1^ERROR, the property type and sub-type is valid and all other types of bathrooms are empty, indicate that the field is required.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk4^TRUE]
//[ErrMsg2^ERROR, the property type and sub-type is valid and update type is 'change' and all old bathroom values are empty, indicate that the field is required.|LogicBlk1^TRUE|LogicBlk3^TRUE|LogicBlk4^TRUE]
// Property type is 'residential' and...
(/*[LogicBlk1]*/PropertyType.IN.('Resi')).AND.
// all other types of bathrooms are empty or...
(/*[LogicBlk2]*/.NOT.((BathroomsFull != .EMPTY.).OR.(BathroomsOneQuarter != .EMPTY.).OR.(BathroomsHalf != .EMPTY.)).OR.
// the update action is 'change' and the last entry value is empty and other bathroom types are empty and...
(/*[LogicBlk3]*/(.UPDATEACTION..IN.('Change').AND.(LASTBathroomsFull = .EMPTY.).AND.(.OLDVALUE. = .EMPTY.).AND.(LASTBathroomsHalf = .EMPTY.).AND.(LASTBathroomsOneQuarter = .EMPTY.)))).AND.
// the property sub-type is not of type 'boat slip' or 'deeded parking' and entry is empty.
(/*[LogicBlk4]*/(.NOT.(PropertySubType.IN.('BSLP','DDPK'))).AND.(.ENTRY. = .EMPTY.))

Syntax only

(PropertyType.IN.('Resi')).AND.(.NOT.((BathroomsFull != .EMPTY.).OR.(BathroomsOneQuarter != .EMPTY.).OR.(BathroomsHalf != .EMPTY.)).OR.((.UPDATEACTION..IN.('Change').AND.(LASTBathroomsFull = .EMPTY.).AND.(.OLDVALUE. = .EMPTY.).AND.(LASTBathroomsHalf = .EMPTY.).AND.(LASTBathroomsOneQuarter = .EMPTY.)))).AND.((.NOT.(PropertySubType.IN.('BSLP','DDPK'))).AND.(.ENTRY. = .EMPTY.))

Rule Unique ID

cd3af5d8-4013-42f6-a902-9b99dc14537b

Rule Number

19