ADO.NET Provider for Basecamp

Build 24.0.8963

Topics

Retrieve Topics on Basecamp.

テーブル固有の情報

Select

すべてのアクティブなTopics、Project に属するTopics のソート、もしくはアーカイブされたTopics のみを取得することができます(ProjectId およびArchived は、Basecamp によって検索条件としてサポートされているカラムです)。

SELECT * FROM Topics WHERE ProjectId = '1111111' ORDER BY UpdatedAt ASC

SELECT * FROM Topics WHERE ProjectId = '1111111' AND Archived = True

Columns

Name Type References Description
Id [KEY] String The unique identifier of the topic.
Archived Boolean Boolean value for archived topics.
Attachments Integer The number of attachments to the topic.
BucketAppUrl String The topic bucket app URL.
BucketColor String The bucket topic color.
BucketId String The bucket topic Id.
BucketName String The bucket topic name.
BucketType String The bucket topic type.
BucketUrl String The bucket topic URL.
CreatedAt Datetime The date and time when the record was created.
Excerpt String The excerpt from the latest comment on the topic.
LastUpdaterId String The Id of the person who made the last comment.
LastUpdaterName String The name of the person who last updated the topic.
Private Boolean Whether the topic is private.
Title String The title of the topic.
TopicableAppUrl String The URL of the topicable Basecamp entity.
TopicableId String The Id of the topicable Basecamp entity.
TopicableType String The type of the topicable Basecamp entity.
TopicableUrl String The URL of the topicable Basecamp entity.
Trashed Boolean Boolean value for deleted topics.
UpdatedAt Datetime The date and time when the record was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ProjectId String The Project Id.

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