Gets all the forums in the given project.

Select

• Id and CategoryId support the following operator: =.

For example, the following query is processed server side:

SELECT * FROM Forums WHERE Id = '123456000000043771' 

Insert

To create a new Forum, you can specify the following fields:

• Name
• Type
• CategoryId
• Content
• Flag
• IsAnnouncementPost
• IsStickyPost
• Notify

To create a new Forum, you can use the below query:

INSERT INTO Forums (Name, Type, CategoryId, Content, Flag, IsAnnouncementPost, IsStickyPost)
VALUES ('Forum Post', 'normal', '123456000000039039', 'Content for Forum Post', 'internal', false, false)

Update

To update a Forum, specify the Id field.

UPDATE Forums
	SET Name = 'Updated Post Name', CategoryId = '123456000000093039', Content = 'Updated forum post content' 
	WHERE Id = '123456000000043771' 

Delete

Forums can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Forums WHERE Id = '123456000000043771' 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	Forum Id.
Name	String	False	Forum Name.
Type	String	False	Forum Type. 使用できる値は次のとおりです。normal, question
Attachments	String	False	Forum Attachments.
CategoryId	String	False	Forum Category Id.
CategoryName	String	False	Forum Category Name.
CommentCount	Integer	False	Forum Comment Count.
Content	String	False	Forum Content.
Flag	String	False	Forum Flag.
IsAnnouncementPost	Boolean	False	Forum Is Announcement Post.
IsStickyPost	Boolean	False	Forum Is Sticky Post.
LastActivityDate	Date	False	Forum Last Activity Date.
LastActivityDateTime	Datetime	False	Forum Last Activity Date Time.
LastModifiedDate	Date	False	Forum Last Modified Date.
LastModifiedDateTime	Datetime	False	Forum Last Modified Date Time.
LinkSelfUrl	String	False	Forum Link Self Url.
PostDate	Date	False	Forum Post Date.
PostDateTime	Datetime	False	Forum Post Date Time.
PostedBy	String	False	Forum Posted By.
PostedByZpuid	String	False	Forum Posted By ZPUID.
PostedPerson	String	False	Forum Posted Person.
ThirdPartyAttachments	String	False	Forum Third Party Attachments.
Notify	String	False	Enter the user mail Ids to be notified (Multiple emails can be comma-separated).