Skip to main content
Planview Customer Success Center

Open task restrictions are not imposed for some tasks

Symptoms
Two tasks named "Task 1" and "Task 2" are created as open tasks and restricted to certain workgroups. The task "Task 2" can be seen in timesheet only by the resources under these workgroups, as expected. However, everyone is able to see the task "Task 1".
 


 

Reason
The option "Enterprise users allowed to enter time for this task" is configured as a mandatory field in System Manager >>User Interface >> Metadata, after the creation of "Task 1". Due to this configuration, the checkbox is displayed as checked in the UI regardless of the corresponding value in the database. Further investigation revealed that the corresponding value for the open task restriction in the database is still "0" for "Task 1", therefore open task restrictions are not imposed on “Task 1”.
(The behaviour of the mandatory fields is by design; if a field is set as mandatory then the value of this field in the existing entities will be set the next time the entity is saved).

Resolution
Follow the steps below to save the open task restriction options:

  1. Edit the task and select an additional workgroup or a role from the restriction list
  2. Save the task
  3. Deselect the workgroup or role that was selected at step 1
  4. Save the task again


Additional notes
The following query can be used to identify such tasks:

select RestrictOpenTasks, t.deleted, opentask, completed, locked, t.name, p.name , p.*
from tasks t inner join project p on p.projectid = t.projectid
where t.deleted=0 and opentask = 1 and RestrictOpenTasks = 0
and completed = 0 and locked = 0 and p.projectstatus = 'A'