Add Worksheet Navigation Entry

  1. Go to Project Administration > Portal > Topics
  2. Select Default view
  3. Add there:
    <topic id="worksheet"/>

Setup Team Work Item Type

  1. Go to Project Administration > Work Items > Types
  2. Setup a new work item type with ID "team"
  3. Setup custom fields for the Team work item
    i.e. go to Project Administration > Work Items > Custom Fields
  4. Create new configuration for type 'Team'
  5. Add multi-valued custom field members of type Enum:User
  6. Add custom field properties of type Text (multi line)


Adjustments

If you want to use other work items than those with type.id:team, or if you want to load the team items from other than current project, use following context property to override the default:

    nextedy.team.query=project.id:{0} AND type:team


You can also change the name of the properties custom field by context property:

nextedy.team.key.properties=properties



Add Team Items

  1. Go to Project > Work Items > Team
  2. Create your teams by creating an item of type "team"
  3. Select team members by using custom field "members"
  4. Optionally setup team "properties"


nextedy.team.worksheet.assignments.rProject=0,8,8,2,2,2,0

nextedy.team.worksheet.items.query.1.label=Unresolved Team Tasks

nextedy.team.worksheet.items.query.1.pattern=assignee.id:{1} AND NOT HAS_VALUE:resolution

nextedy.team.worksheet.items.query.2.label=Resolved Team Tasks

nextedy.team.worksheet.items.query.2.pattern=assignee.id:{1} AND  HAS_VALUE:resolution

nextedy.team.workRecordsItemsQuery=type:task

nextedy.team.eventItemsQuery=project.id:{2} AND type:(event) AND assignee.id:{1}