Email Statusing Service Activity Filter Options
As a team member or project manager, you must follow the syntax and formatting for the filter options below when sending a request to Email Statusing Service.
Filter Options
There are three types of request filters: Status, Time Frame, and Project. A status request is a minimum requirement; a time frame and project request are optional extensions to the status request.
For team members, a valid request for an activity list would appear in the email subject line as:
<Status> <Time Frame, optional> <Project, optional>
Note: If you need assistance with the options, syntax, or required formatting of these messages, send an email message with only the word Help
or a ?
in the subject line to receive more detailed instructions. In addition, if your status request message is ever invalid, you will be notified by email.
For project managers, a valid request to send a notification email to team members would appear in the subject line as:
Notify <Status> <Time Frame, optional> <Project, optional>
Status Options
Active
Activities that are in progress or have not started.
Due
Activities scheduled to finish today.
Overdue
Activities that were scheduled to finish prior to today.
Completed
Activities where the finished date is today's date.
Starting
Activities that are scheduled to start today.
Starred
Activities team members marked as important. This filter can only be combined with a Project ID or Project Name filter. The starring feature is not available to users assigned Team Member work distribution filters.
Time Frame Options
Requests by status can optionally be filtered based on a specified number of days, weeks, or months, or by specifying today, tomorrow, or yesterday.
Active in next <number> <units of time>
Activities that are in progress or scheduled to start in the next number of days, weeks, or months.
Example: Active in next 3 weeks
Active Today
Activities that are in progress or are scheduled to start on or before today's date.
Active Tomorrow
Activities that are in progress or are scheduled to start on or before tomorrow's date.
Due in next <number> <units of time>
Activities that should be completed in the next number of days, weeks, or months.
Example: Due in next 5 days
Due Today
Activities scheduled to finish today.
Due Tomorrow
Activities that are scheduled to finish tomorrow.
Completed in last <number> <units of time>
Activities that were completed in the last number of days, weeks, or months.
Example: Completed in last 3 days
Notes:
- There is a 180 day limit to viewing completed activities . Any completed activity with a Finished Date more than 180 days in the past will not be returned.
- If the completed activity was updated with a Finished Date within the past 180 days and the last approved Finished Date is more than 180 days in the past, the activity will not be sent to you regardless of the updated Finished Date. (This only applies if Team Member status updates require approval.)
Completed Today
Activities where the finished date is today's date.
Completed Yesterday
Activities where the finished date is yesterday's date.
Starting in next <number> <units of time>
Activities that are scheduled to start in the next number of days, weeks, month.
Example: Starting in next 1 month
Starting Today
Activities that are scheduled to start today.
Starting Tomorrow
Activities that are scheduled to start tomorrow.
Project Options
Requests by status can optionally be filtered based on an active project name or project ID.
on Project <Project ID or Name>
Restricts the results of the requested status and optional time frame filter to the activities that belong to the specified active project. If no project is specified, all active projects for which you have access rights will be included.
Examples:
- Overdue on project MFG00925
- Due in next 5 days on project Plant Expansion and Modernization
Fields Available for Activity Status Updates
The fields available in the email are assigned by the project manager in P6. Also, in P6, team members are assigned as either a resource assignment, an activity owner, or a user with a Team Member work distribution filter. Project managers should let team members know what fields are assigned to them and whether they are a resource assignment, an activity owner, or a user with a Team Member work distribution filter because some of the status fields depend on their role.
The updates you can make to the fields that are returned depend on the activity status (Not Started, In Progress, or Completed). Use the following table to determine which fields can be updated for a Not Started, In Progress, or Completed activity.
Table of Activity Status Fields Available by Email
Resource Assignment
Field | Status: Not Started | Status: In Progress | Status: Completed | Sample Value |
---|---|---|---|---|
Start/Started Date | Yes | Yes | Yes |
|
Finish/Finished Date | Yes | Yes | Yes |
|
Time Spent | Yes | Yes | Yes |
|
Time Left | Yes | Yes | No |
|
Remaining Duration | Yes | Yes | No |
|
Finished (Y/N) | Yes | Yes | No |
|
Starred (Y/N) | Yes | Yes | No |
|
Activity Owner or User Assigned a Team Member Work Distribution Filter
Field | Status: Not Started | Status: In Progress | Status: Completed | Sample Value |
---|---|---|---|---|
Start/Started Date | Yes | Yes | Yes |
|
Finish/Finished Date | No | No | Yes |
|
Activity % Complete (see notes) | Yes | Yes | No |
|
Expected Finish | Yes | Yes | No |
|
Time Spent (Labor/Nonlabor) | Yes | Yes | Yes |
|
Time Left (Labor/Nonlabor) | Yes | Yes | No |
|
Remaining Duration | Yes | Yes | No |
|
Finished (Y/N) | Yes | Yes | No |
|
Starred (Y/N) (see notes) | Yes | Yes | No |
|
Notes for Activity % Complete:
- The calculation of the Activity % Complete field depends on the settings your project manager configured in P6. The field is either calculated using units or duration, calculated using the percentage complete from steps, or a value you enter based on your own perception of the work you completed on this activity.
- When you enter 100% to indicate your work is complete, you must also enter Y for Finished (Y/N) to mark this activity complete.
Note for Starred (Y/N): The starring feature is not available to users assigned Team Member work distribution filters.
Last Published Tuesday, March 26, 2024