ToDoLists
Retrieve ToDoLists on Basecamp.
テーブル固有の情報
Select
次のカラムはBasecamp において検索条件としてサポートされています：
- ProjectId
- Id
- PersonId
- Completed
- Trashed
- CreatedAt
CreateAt は'>' もしくは'>=' 演算子と共に使うことができます。
次のクエリは、特定の日にちから、あるProject に属する完了されたToDoLists のみを取得します：
SELECT * FROM ToDoLists WHERE ProjectId = '11111111' AND Completed = True AND CreatedAt > '2016-01-01'M
次のクエリは、あるProject から1つのToDoList を取得します。
SELECT * FROM ToDoLists WHERE ProjectId = '11111111' AND Id = '123456789'
次のクエリは、ある個人にアサインされたToDoLists を取得します。
SELECT * FROM ToDoLists WHERE PersonId = '11111111'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the topic. | |
| AppUrl | String | The app URL. | |
| AssignedTodos | String | Assigned to-dos. | |
| BucketAppUrl | String | The topic bucket app URL. | |
| BucketColor | String | The to-do bucket color. | |
| BucketId | String | The to-do bucket Id. | |
| BucketName | String | The to-do bucket name. | |
| BucketType | String | The to-do bucket type. | |
| BucketUrl | String | The to-do bucket URL. | |
| Completed | Boolean | Whether the to-do list is completed. | |
| CompletedCount | Integer | Number of completed to-dos. | |
| CreatedAt | Datetime | The date and time when the record was created. | |
| CreatorAvatarUrl | String | Creator Avatar URL. | |
| CreatorFullsizeAvatarUrl | String | Creator full-size avatar URL. | |
| CreatorId | String | The Id of the creator. | |
| CreatorName | String | The name of the creator. | |
| Description | String | The to-do list description. | |
| Name | String | The name of the to-do list. | |
| Position | Integer | Position number of the current to-do list. | |
| Private | Boolean | Whether the to-do list is private. | |
| RemainingCount | Integer | Number of unfinished to-dos. | |
| SubscribersId | String | The Id of the subscriber. | |
| SubscribersName | String | The name of the subscriber. | |
| ToDos | String | To-dos list. | |
| Trashed | Boolean | Boolean value for deleted to-do lists. | |
| UpdatedAt | Datetime | The date and time when the record was last updated. | |
| URL | String | The URL of the to-do list. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ProjectId | String | The Id of the Project associated with the to-do list. | |
| PersonId | String | The Id of the Person associated with the to-do list. |