ForumComments
Gets all the forum comments.
Select
- ForumId is required to retrieve Forum Comments.
'Id' column supports filtering using '=' operator.
- Columns that support server-side ORDER BY: CreatedTime.
SELECT * FROM ForumComments WHERE ForumId = '123456000000045018' ORDER BY CreatedTime
Insert
To create a new Forum Comment you can use the below query:
INSERT INTO ForumComments (ForumId, Content, ParentId)
VALUES ('123456000000045028', 'Forum Comment Reply', '123456000000043083')
Update
Forum Comments can be updated by providing the Id, ForumId and issuing a UPDATE statement.
UPDATE ForumComments SET Content = 'new comm!!' WHERE Id = '123456000000043083' AND ForumId = '123456000000045028'
Delete
Forum Comments can be deleted by providing the Id, ForumId and issuing a DELETE statement.
DELETE FROM ForumComments WHERE Id = '123456000000043083' AND ForumId = '123456000000045028'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Long | True |
Forum Comment Id. |
| ForumId [KEY] | Long | False |
Forum Id. |
| Content | String | False |
Forum Comment Content. |
| Type | String | False |
Forum Comment Type. The allowed values are question, answer, normal. |
| IsBestAnswer | Boolean | True |
Forum Comment Is Best Answer. |
| Level | Integer | True |
Forum Comment Level. |
| PostedById | Long | True |
Forum Comment Posted By Id. |
| PostedByBusinessHoursId | Long | True |
Forum Comment Posted By Business Hours Id. |
| PostedByFirstName | String | True |
Forum Comment Posted By First Name. |
| PostedByLastName | String | True |
Forum Comment Posted By Last Name. |
| PostedByName | String | True |
Forum Comment Posted By Name. |
| PostedByFullName | String | True |
Forum Comment Posted By Full Name. |
| PostedByEmail | String | True |
Forum Comment Posted By Email. |
| PostedByZpuid | Long | True |
Forum Comment Posted By Zpuid. |
| PostedByIsClientUser | Boolean | True |
Forum Comment Posted By Is Client User. |
| CreatedTime | Datetime | True |
Forum Comment Created Time. |
| LastActivityTime | Datetime | True |
Forum Comment Last Activity Time. |
| LastModifiedTime | Datetime | True |
Forum Comment Last Modified Time. |
| LastModifiedById | Long | True |
Forum Comment Last Modified By Id. |
| LastModifiedByBusinessHoursId | Long | True |
Forum Comment Last Modified By Business Hours Id. |
| LastModifiedByFirstName | String | True |
Forum Comment Last Modified By First Name. |
| LastModifiedByLastName | String | True |
Forum Comment Last Modified By Last Name. |
| LastModifiedByName | String | True |
Forum Comment Last Modified By Name. |
| LastModifiedByFullName | String | True |
Forum Comment Last Modified By Full Name. |
| LastModifiedByEmail | String | True |
Forum Comment Last Modified By Email. |
| LastModifiedByZpuid | Long | True |
Forum Comment Last Modified By Zpuid. |
| LastModifiedByIsClientUser | Boolean | True |
Forum Comment Last Modified By Is Client User. |
| AddedVia | String | True |
Forum Comment Added Via. |
| ParentId | Long | False |
Forum Comment Parent Id. |
| RootId | Long | False |
Forum Comment Root Id. |
| ParentPostedById | Long | True |
Forum Comment Parent Posted By Id. |
| ParentPostedByBusinessHoursId | Long | True |
Forum Comment Parent Posted By Business Hours Id. |
| ParentPostedByFirstName | String | True |
Forum Comment Parent Posted By First Name. |
| ParentPostedByLastName | String | True |
Forum Comment Parent Posted By Last Name. |
| ParentPostedByName | String | True |
Forum Comment Parent Posted By Name. |
| ParentPostedByFullName | String | True |
Forum Comment Parent Posted By Full Name. |
| ParentPostedByEmail | String | True |
Forum Comment Parent Posted By Email. |
| ParentPostedByZpuid | Long | True |
Forum Comment Parent Posted By Zpuid. |
| ParentPostedByIsClientUser | Boolean | True |
Forum Comment Parent Posted By Is Client User. |
| Attachments | String | False |
Forum Comment Attachments. Pass array of Attachments Id's when adding/updating a forum comment. |
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 comment. |
| ThirdpartyId | String |
Array of the WorkDrive resource IDs of the files to associate. |