Tableau Connector for Zoho Projects

Build 22.0.8462

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
LastModifiedTime Datetime

Task Comment Last Modified Time.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462