Tasks
Create, update, query, and delete items in a SharePoint Tasks list.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The ID of the item. The format of the ID is: List|ItemID. |
| List | String | False |
The name of the issue tracking list. |
| Title | String | False |
The title of the item. |
| Priority | String | False |
The priority of the task. |
| Status | String | False |
The status of the task. |
| PercentComplete | String | False |
The completed progress of the task, expressed as a percentage. |
| AssignedTo | String | False |
The SharePoint user the task is assigned to. |
| TaskGroup | String | False |
The SharePoint group the task is assigned to. |
| Body | String | False |
The description of the item. |
| StartDate | Date | False |
The start date of the task. |
| DueDate | Date | False |
The due date of the task. |
| WorkflowName | String | False |
The name of the workflow associated with the task. |
| Author | String | False |
The user that created the item. |
| Editor | String | False |
The last user that modified the item. |
| Modified | Date | False |
The date modified. |
| Created | Date | False |
The date created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CAMLQuery | String |
The query to be used while listing the list items. |