Cannot select blocked projects when editing a firm

This section provides information on a validation error.

Workflow Table Type Description Workflow Conditions
Firm Change Blocked Projects cannot be selected (Change)
Action Column (Field) Change Properties Description Action Conditions
Column (Field) Change Column: ClientCustomTabFields.CustWorkflowBlockedProject

New Value SQL Expression:

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

Use this Calculation: 'Y'

Otherwise, Use This Calculation: 'N'

Test if blocked Location was selected ClientCustomTabFields.CustProject not empty AND

ClientCustomTabFields.CustProject has changed

Validate Error You've chosen a blocked Project. Please select a different Project. ClientCustomTabFields.CustWorkflowBlockedProject equals Y