MyTasks
Gets all your tasks in the portal.
Select
This is a portal-level view. Columns that support the = operator:- Id
- CreatedBy
- MilestoneId
- Priority
- TasklistId
- Owner
- Status
- Time
- LastModifiedTime
- ViewId
For example, the following query is processed server side:
SELECT * FROM MyTasks WHERE MilestoneId = '12345600000123' AND Priority = 'High'
Columns
| Name | Type | Description |
| ProjectId | String | Project Id. |
| Id [KEY] | String | Task Id. |
| Name | String | Task Name. |
| Key | String | Task Key. |
| BillingType | String | Task Billing Type. |
| Completed | Boolean | Task Completed. |
| CreatedBy | String | Task Created By. |
| CreatedByEmail | String | Task Created By Email. |
| CreatedByZpuid | String | Task Created By Zpuid. |
| CreatedPerson | String | Task Created Person. |
| CreatedDate | Date | Task Created Date. |
| CreatedDateTime | Datetime | Task Created Date Time. |
| Description | String | Task Description. |
| Owners | String | Task Owners. |
| Duration | String | Task Duration. |
| DurationType | String | Task Duration Type. |
| EndDate | Date | Task End Date. |
| EndDateTime | Datetime | Task End Date Time. |
| CommentAdded | Boolean | Task Comment Added. |
| DocsAssociated | Boolean | Task Docs Associated. |
| ForumAssociated | Boolean | Task Forum Associated. |
| RecurrenceSet | Boolean | Task Recurrence Set. |
| ReminderSet | Boolean | Task Reminder Set. |
| Parent | Boolean | Task Parent. |
| LastUpdatedDate | Date | Task Last Updated Date. |
| LastUpdatedDateTime | Datetime | Task Last Updated Date Time. |
| LinkSelfUrl | String | Task Link Self Url. |
| LinkTimesheetUrl | String | Task Link Timesheet Url. |
| LinkWebUrl | String | Task Link Web Url. |
| LogHoursBillableHours | String | Task Log Hours Billable Hours. |
| LogHoursNonBillableHours | String | Task Log Hours Non Billable Hours. |
| MilestoneId | String | Task Milestone Id. |
| OrderSequence | Integer | Task Order Sequence. |
| PercentComplete | String | Task Percent Complete. |
| Priority | String | Task Priority.
使用できる値は次のとおりです。none, low, medium, high |
| StartDate | Date | Task Start Date. |
| StartDateTime | Datetime | Task Start Date Time. |
| StatusColorCode | String | Task Status Color Code. |
| StatusId | String | Task Status Id. |
| StatusName | String | Task Status Name. |
| StatusType | String | Task Status Type. |
| Subtasks | Boolean | Task Subtasks. |
| TaskFollowers | String | Task Task Followers. |
| TaskFollowerSize | Integer | Task Task Follower Size. |
| TasklistId | String | Task Tasklist Id. |
| TasklistIdString | String | Task Tasklist Id String. |
| TasklistName | String | Task Tasklist Name. |
| Work | String | Task Work. |
| WorkForm | String | Task Work Form. |
| WorkType | String | Task Work Type. |
| GroupNameAssociatedTeamsAnyTeam | String | Task Group Name Associated Teams Any Team. |
| GroupNameAssociatedTeamsCount | Integer | Task Group Name Associated Teams Count. |
| GroupNameIsTeamUnassigned | Boolean | Task Group Name Is Team Unassigned. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Owner | String | Task Owner. |
| Status | String | Task Status.
使用できる値は次のとおりです。completed, notcompleted |
| Time | String | Task Time.
使用できる値は次のとおりです。overdue, today, tomorrow |
| LastModifiedTime | Datetime | Task Last Modified Time. |
| CustomViewId | String | Task Custom View Id. |