BulletinTopicsDraft
Query bulletin board draft topics by ID. The Id column is required for querying.
Select
The 本製品 will use the Garoon API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Id supports the '=' operator and is required for querying.
For example, the following query is processed server side:
SELECT * FROM BulletinTopicsDraft WHERE Id = 3
Columns
| Name | Type | Description |
| Id [KEY] | String | ID of the draft topic. |
| Subject | String | Subject of the draft topic. |
| CategoryId | String | ID of the category. |
| CategoryName | String | Name of the category. |
| PublicPeriodIsUnlimited | Boolean | Whether the public period is unlimited. |
| PublicPeriodStart | Datetime | Start of the public period. |
| PublicPeriodEnd | Datetime | End of the public period. |
| CreatedAt | Datetime | Creation date and time. |
| CreatorId | String | Creator's Garoon user ID. |
| CreatorCode | String | Creator's login name. |
| CreatorName | String | Creator's display name. |
| UpdatedAt | Datetime | Update date and time. |
| UpdaterId | String | Updater's Garoon user ID. |
| UpdaterCode | String | Updater's login name. |
| UpdaterName | String | Updater's display name. |
| ManuallySender | String | Manually entered sender name. |
| Body | String | Body of the draft topic. |
| IsHtmlBody | Boolean | Whether the body is HTML format. |
| AllowComments | Boolean | Whether comments are allowed. |
| OperatorType | String | Change or delete permission type. |
| Operators | String | Users or groups with change or delete permission. |
| Acknowledgement | Boolean | Whether reading acknowledgement is required. |
| Attachments | String | Files attached to the draft topic. |
| IsDraft | Boolean | Whether the topic is a draft. |
| IsPublished | Boolean | Whether the topic has been published. |
| IsExpired | Boolean | Whether the public period of the topic has expired. |