TaskComments

Get all the task comments.

Select

TaskId is required to retrieve Task Comments.
CreatedTime and UpdatedTime supports ORDER BY server side.

For example, the following query is processed server side:

SELECT * FROM TaskComments WHERE TaskId = '123456000000040013'

Insert

To add a Task Comment specify the TaskId and Comment fields.

INSERT INTO TaskComments (TaskId, comment) VALUES ('123456000000040013', 'SQL Comment #6')

Update

To update a Task Comments specify the Id field.

UPDATE TaskComments
	SET Comment = 'Updated forum post content' 
	WHERE Id = '123456000000043771' AND TaskId = '123456000000040013'

Delete

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

DELETE FROM TaskComments WHERE TaskId = '123456000000045005' AND Id = '123456000000045042'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Unique identifier of the comment.
TaskId	Long	False	Task Id.
Comment	String	False	Task Comment Content.
AddedVia	String	True	Source of comment creation.
CreatedById	Long	True	ID of the creator.
CreatedByZpuid	Long	True	Portal-specific user ID of the creator.
CreatedByBusinessHoursId	Long	True	Business Hours ID of the creator.
CreatedByName	String	True	Display name of the creator.
CreatedByEmail	String	True	Email address of the creator.
CreatedByFirstName	String	True	First name of the creator.
CreatedByLastName	String	True	Last name of the creator.
CreatedByFullName	String	True	Full name of the creator.
CreatedByIsClientUser	Boolean	True	Indicates whether the creator is a client user.
UpdatedById	Long	True	ID of the last updater.
UpdatedByZpuid	Long	True	Portal-specific user ID of the last updater.
UpdatedByBusinessHoursId	Long	True	Business Hours ID of the updater.
UpdatedByName	String	True	Display name of the last updater.
UpdatedByEmail	String	True	Email address of the last updater.
UpdatedByFirstName	String	True	First name of the last updater.
UpdatedByLastName	String	True	Last name of the last updater.
UpdatedByFullName	String	True	Full name of the last updater.
UpdatedByIsClientUser	Boolean	True	Indicates whether the last updater is a client user.
SprintsId	Integer	True	Identifier of the sprint associated with the comment.
SalesIqChatId	Integer	True	Identifier of the salesiq chat associated with the comment.
CrmId	Integer	True	Identifier of the CRM record associated with the comment.
DeskId	Integer	True	Identifier of the Desk ticket associated with the comment.
CreatedTime	Datetime	True	Timestamp of when the comment was created.
UpdatedTime	Datetime	True	Timestamp of the most recent update.
Attachments	String	False	Attachments associated with the 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
ThirdpartyId	String	Array of the WorkDrive resource IDs of the files to associate.