Forums
Gets all the forums in the given project.
Select
Following columns support the '=' operator:
- Id
- Title
- CategoryId
- Flag
- IsAnnouncementPost
- IsStickyPost
- PostedById
- Columns that support server-side ORDER BY: CreatedTime, LastActivityTime, LastModifiedTime
SELECT * FROM Forums WHERE Id = '123456000000043771'
Insert
To create a new Forum, you can specify the following fields:
- Title
- Type
- CategoryId
- Content
- Flag
- IsAnnouncementPost
- IsStickyPost
- Attachments
- Tags
- Notify
- ThirdpartyId
To create a new Forum, you can use the below query:
INSERT INTO Forums (Title, 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 Title = '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] | Long | True |
Forum Id. |
| Title | String | False |
Forum Title. |
| Type | String | False |
Forum Type. The allowed values are normal, question. |
| CategoryId | Long | False |
Forum Category Id. |
| CategoryName | String | True |
Forum Category Name. |
| Content | String | False |
Forum Content. |
| ProjectId | Long | True |
Forum Project Id. |
| ProjectName | String | True |
Forum Project Name. |
| CommentCount | Integer | True |
Forum Comment Count. |
| TaskCount | Integer | True |
Forum Task Count. |
| FollowersCount | Integer | True |
Forum Followers Count. |
| Flag | String | False |
Forum Flag. The allowed values are internal, external. |
| IsAnnouncementPost | Boolean | False |
Forum Is Announcement Post. |
| IsStickyPost | Boolean | False |
Forum Is Sticky Post. |
| PostedById | Long | True |
Forum Posted By Id. |
| PostedByBusinessHoursId | Long | True |
Forum Posted By Business Hours Id. |
| PostedByFirstName | String | True |
Forum Posted By First Name. |
| PostedByLastName | String | True |
Forum Posted By Last Name. |
| PostedByName | String | True |
Forum Posted By Name. |
| PostedByFullName | String | True |
Forum Posted By Full Name. |
| PostedByEmail | String | True |
Forum Posted By Email. |
| PostedByZpuid | Long | True |
Forum Posted By Zpuid. |
| PostedByIsClientUser | Boolean | True |
Forum Posted By Is Client User. |
| CreatedTime | Datetime | True |
Forum Created Time. |
| LastActivityTime | Datetime | True |
Forum Last Activity Time. |
| LastModifiedTime | Datetime | True |
Forum Last Modified Time. |
| LastModifiedById | Long | True |
Forum Last Modified By Id. |
| LastModifiedByBusinessHoursId | Long | True |
Forum Last Modified By Business Hours Id. |
| LastModifiedByFirstName | String | True |
Forum Last Modified By First Name. |
| LastModifiedByLastName | String | True |
Forum Last Modified By Last Name. |
| LastModifiedByName | String | True |
Forum Last Modified By Name. |
| LastModifiedByFullName | String | True |
Forum Last Modified By Full Name. |
| LastModifiedByEmail | String | True |
Forum Last Modified By Email. |
| LastModifiedByZpuid | Long | True |
Forum Last Modified By Zpuid. |
| LastModifiedByIsClientUser | Boolean | True |
Forum Last Modified Time. |
| AddedVia | String | True |
Forum Added Via. |
| MailTo | String | True |
Forum mail to. |
| Attachments | String | False |
Forum Attachments. Pass array of Attachments Id's when adding/updating a forum. |
| Tags | String | False |
Forum Tags. Pass array of Tag Id's when adding/updating a forum. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| Notify | String |
Array of the ZUIDs of the users to notify about this forum. |
| ThirdpartyId | String |
Array of the WorkDrive resource IDs of the files to associate. |