MyMilestones
Get all the milestones assigned to a particular user in the given project.
Select
This is a portal-level view.- ProjectId and Flag support the following operator: =.
- ProjectId supports the operator: IN
- CreatedDate and LastModifiedTime support: ORDER
SELECT * FROM MyMilestones WHERE ProjectId IN ('12345000000030899', '12345000000033005') AND Flag = 'internal' ORDER BY CreatedDate
Columns
| Name | Type | Description |
| ProjectId | String | Project Id. |
| Id [KEY] | String | Milestone Id. |
| Name | String | Milestone Name. |
| Closed | Boolean | Milestone Closed. |
| CreatedDate | Date | Milestone Created Date. |
| CreatedDateTime | Datetime | Milestone Created Date Time. |
| EndDate | Date | Milestone End Date. |
| EndDateTime | Datetime | Milestone End Date Time. |
| Flag | String | Milestone Flag.
使用できる値は次のとおりです。internal, external |
| IsWorkfieldRemoved | Boolean | Milestone Is Work Field Removed. |
| LastUpdatedDate | Date | Milestone Last Updated Date. |
| LastUpdatedDateTime | Datetime | Milestone Last Updated Date Time. |
| SelfUrl | String | Milestone Self Url. |
| StatusUrl | String | Milestone Status Url. |
| OwnerId | String | Milestone Owner Id. |
| OwnerName | String | Milestone Owner Name. |
| OwnerZpuid | String | Milestone Owner ZPUID. |
| ProjectName | String | Milestone Project Name. |
| Sequence | Integer | Milestone Sequence. |
| StartDate | Date | Milestone Start Date. |
| StartDateTime | Datetime | Milestone Start Date Time. |
| Status | String | Milestone Status. |
| StatusColorCode | String | Milestone Status Color Code. |
| StatusId | String | Milestone Status Id. |
| StatusName | String | Milestone Status Name. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| LastModifiedTime | Datetime | Milestone Last Modified Time. |