Get all the task comments.

Select

• TaskId is required to retrieve Task Comments.
• LastModifiedTime supports the following operator: =.

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, content) VALUES ('123456000000040013', 'SQL Comment #6')

Update

To update a Task Comments specify the Id field.

UPDATE TaskComments
	SET Content = '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
TaskId [KEY]	String	False	Task Id.
Id [KEY]	String	False	Task Comment Id.
Content	String	False	Task Comment Content.
AddedPersonId	String	False	Task Comment Added Person Id.
AddedPersonName	String	False	Task Comment Added Person Name.
AddedVia	String	False	Task Comment Added Via.
Attachments	String	False	Task Comment Attachments.
CreatedDate	Date	False	Task Comment Created Date.
CreatedDateTime	Datetime	False	Task Comment Created Date Time.
LastModifiedDate	Date	False	Task Comment Last Modified Date.
LastModifiedDateTime	Datetime	False	Task Comment Last Modified Date Time.
ProjectName	String	False	Task Comment Project Name.
SprintsNotesId	Integer	False	Task Comment Sprints Notes Id.
ThirdPartyAttachments	String	False	Task Comment Third Party Attachments.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastModifiedTime	Datetime	Task Comment Last Modified Time.