Messages
Retrieve messages on Basecamp 3.
テーブル固有の情報
You can query messages posted on the message board of the specified project.
Select
The columns supported as search criteria by Basecamp are ProjectId, MessageBoardId.
If ProjectId is not specified in the query, the default ProjectId will be used.
SELECT * FROM Messages WHERE ProjectId = '11111111' AND MessageBoardId = '22222222'
You can also retrieve a single message by specifying the Id.
SELECT * FROM Messages WHERE ProjectId = '11111111' AND Id = '33333333'
Insert
You can insert a new message, by providing the required ProjectId, MessageBoardId, and Subject in addition to the message related parameters.
INSERT INTO Messages (ProjectId, MessageBoardId, Content, Subject, Status ) VALUES ('1111111', '2222222', 'Content test', 'Subject test', 'active')
Update
You can also update messages by providing the ProjectId and message Id.
UPDATE Messages SET subject = 'Updated subject', content = 'Updated content' WHERE ProjectId = '11111111' AND Id = '1234567689'
Delete
Messages cannot be deleted.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique identifier of the message. | |
| ProjectId | Long | True |
Projects.Id |
The Project Id associated with the schedule. |
| MessageBoardId | Long | True |
Projects.MessageBoardId |
The Message Board Id that the message belongs to. |
| Status | String | False |
The status of the message | |
| Type | String | True |
The type of the returned record. | |
| CreatedAt | Datetime | True |
The date and time when the message was created. | |
| UpdatedAt | Datetime | True |
The date and time when the message was last updated. | |
| Content | String | False |
Provided content for the message | |
| Subject | String | False |
Subject of the message | |
| ParentTitle | String | True |
Title of the parent. | |
| ParentType | String | True |
Type of the parent. | |
| BucketName | String | True |
Name of the containing bucket. | |
| BucketType | String | True |
Type of the containing bucket. | |
| CreatorId | Long | True |
People.Id |
The Id of the creator. |
| CreatorName | String | True |
The name of the creator. | |
| CategoryId | Long | False |
The Id of the category. | |
| CategoryName | String | True |
The name of the category. | |
| CommentsCount | Integer | True |
Number of comments the document has. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| IncludeReplies | Boolean |
Set this to true to retrieve replies for each message. |