Cannot select blocked locations when editing a project

This section provides information on a validation error.

Workflow Table Type Level Description Workflow Conditions
Project Change Project Blocked Locations cannot be selected (Change)
Action Level Column (Field) Change Properties Description Action Conditions
Column (Field) Change Project Column: Workflow Blocked Location

New Value SQL Expression:

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

Use this Calculation: 'Y'

Otherwise, Use This Calculation: 'N'

Test if blocked Location was selected Location Dimension not empty AND

Location Dimension has changed

Validate Error Project You've chosen a blocked Location. Please select a different Location. Workflow Blocked Location equals Yes