ADO.NET Provider for Basecamp

Build 24.0.8963

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963