Excel Add-In for Zoho Projects

Build 23.0.8839

TaskComments

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.

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