Cannot select blocked entities when adding a firm

This section provides information on a validation error.

Workflow Table Type Description Workflow Conditions
Firm Insert Blocked Entities cannot be selected (Add)
Action Column (Field) Change Properties Description Action Conditions
Column (Field) Change Column: ClientCustomTabFields.CustWorkflowBlockedEntity

New Value SQL Expression:

If this is True: (select custBlocked from UDIC_Entity where UDIC_UID='[:ClientCustomTabFields.custEntity]')='[BLOCKED]'

Use this Calculation: 'Y'

Otherwise, Use This Calculation: 'N'

Test if blocked Entity was selected ClientCustomTabFields.CustEntity not empty
Validate Error You've chosen a blocked Entity. Please select a different Entity. ClientCustomTabFields.CustWorkflowBlockedEntity equals Y