Skip to main content
Planview Customer Success Center

Can an entity-based UDF field be updated by adding filter to search for active resources only when creating new projects?

Create the resource-based entity type field using a SQL statement, add a filter and use the following statement

where resources.resourceid in (select resourceid from workgroupmember with (nolock) where historical = 0) and resources.deleted = 0

Note that after an entity-based field has been used in Enterprise; that is, data has been saved in it, you can no longer change (update) the entity type, the SQL statement or filter.

You can only select active resources (i.e. one that belongs to a workgroup). If a resource is already selected in the field and is unassigned later, that resource will still show in the field when the project is edited.