Excel Add-In for Zoho Projects

Build 23.0.8839

Forums

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).

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