BulletinTopics

Query bulletin board topics by ID. The Id column is required for querying.

Select

本製品は Garoon API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアント側で本製品内部で処理されます。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM BulletinTopics WHERE Id = 3


Name	Type	Description
Id [KEY]	String	ID of the bulletin topic.
Subject	String	Subject of the bulletin 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.
Body	String	Body of the bulletin 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 bulletin 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.