MyPhases
Get all the phases assigned to a particular user.
Select
This is a portal-level view.- Id supports '=' operator
- Name supports '=,!=,CONTAINS' operators
- Flag supports '=,!=,CONTAINS' operators
- StartDate supports '=,!=,>,>=,<,<=' operators
- EndDate supports '=,!=,>,>=,<,<=' operators
- ViewId supports '=' operator
- MilestoneIds supports '=' operator
StartDate, EndDate, CreatedTime, and LastModifiedTime columns support ORDER BY server side.
For example, the following query is processed server side:
SELECT * FROM MyPhases WHERE Id = '123456000000043771'
Columns
| Name | Type | Description |
| Id [KEY] | Long | Phase Id. |
| Name | String | Phase Name. |
| Flag | String | Phase Flag.
The allowed values are internal, external. |
| StartDate | Date | Phase Start Date. |
| EndDate | Date | Phase End Date. |
| CreatedTime | Datetime | Phase Created Time. |
| OwnerFirstName | String | Phase Owner First Name. |
| OwnerLastName | String | Phase Owner Last Name. |
| OwnerName | String | Phase Owner Name. |
| OwnerEmail | String | Phase Owner Email. |
| OwnerZpuid | Long | Phase Owner Zpuid. |
| OwnerZuid | Long | Phase Owner Zuid. |
| StatusId | Long | Phase Status Detail Id. |
| StatusName | String | Phase Status Detail Name. |
| StatusColor | String | Phase Status Detail Color. |
| StatusColorHexCode | String | Phase Status Detail Color HexCode. |
| StatusIsClosedType | Boolean | Indicates if status is closed. |
| Sequence | Integer | Phase Sequence. |
| ProjectId | Long | Project Id. |
| ProjectName | String | Project Name. |
| LastModifiedTime | Datetime | Phase Last Modified Time. |
| CreatedByFirstName | String | Phase Created By First Name. |
| CreatedByLastName | String | Phase Created By Last Name. |
| CreatedByName | String | Phase Created By Name. |
| CreatedByEmail | String | Phase Created By Email. |
| CreatedByZuid | Long | Phase Created By Zuid. |
| CreatedByZpuid | Long | Phase Created By Zpuid. |
| Color | String | The hex color code to be used for the phase's Gantt bar. |
| Tags | String | Phase Tags. |
| ViewId | Long | Identifier of a custom view to filter phases. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| PhaseIds | String | The comma-separated phase IDs to retrieve specific records. |